Show Database in Design Mode

tmurj

New Member
Joined
Jun 21, 2007
Messages
23
I have inherited a database that has a switchboard, the database window is hidden at start up and the bypass keys are disabled. Essentially the database is in user-friendly mode to protect the underlying data tables, queries, reports, etc.

I have to do some modifications to several forms and reports so I need to get into design mode. I as fairly versed in VBA and pretty familiar with access.

Any suggestions on how to enable the database window via code (or at least get into it) without having to import everything into a new database. Thanks in advance.
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,249
Office Version
  1. 365
Platform
  1. Windows
Sorry, I had to remove the reply that was posted here. We do not help with breaking passwords here on this site (see here):
http://www.mrexcel.com/forum/showthread.php?t=191239

I do not know if the problem is that the database is password protected. If it is, we cannot help you with that.
 

tmurj

New Member
Joined
Jun 21, 2007
Messages
23
Sorry Joe for not clarifying - there is no password on the database. I respect the rule on this and would not seek that kind of help here.

I just need help getting into design mode in order to create some enhancements to some reports and forms.

The database starts up with a menu form and I can not use the shift ket to bypass it starting that form nor can I get the database window to show up.

Any help would be greatly appreciated.
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,344
Office Version
  1. 365
Platform
  1. Windows
If the shift key and Enter does not work, try using F11 once the db is opened.

Alan
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
You may have to import to a new DB first, then redo the startup options.
Unless the original developer has provided a form with a button that enables bypass and / or displays the window, you will need to create some code to do it. I don't have the specifics to hand but it involves using VBA to create a couple of properties which can then be toggled to allow or block the bypass keys.
See if Google helps at all, otherwise get your hands on a copy of Real World Microsoft Access Database Protection and Security by Garry Robinson. I think the publisher is Apress.

Denis
 

Forum statistics

Threads
1,136,333
Messages
5,675,175
Members
419,552
Latest member
jsanjur

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top