Main form ... command button to open in design mode?

B

Brook

good day all,

I have my db set up to open to my main "switchboard" when I open my db. I
was wondering if there was a way to open the db in design mode (maybe with a
password) so that I could easily make behind the scenes modifications...

Any suggestions?

Thanks,

Brook
 
D

Duane Hookom

Hold down a shift key when opening your MDB or press F11 or view the
database window.
 
D

Duane Hookom

You could use code like:
DoCmd.SelectObject acTable, "tblOneOfYourTables", True
 
D

Douglas J Steele

It should probably be pointed out that in Access 2000 and newer, you must
have the database opened exclusively to be able to save any changes you
might make.
 
Top