Can't see tables!!

[rubyred77]

I'm not very good at this program - as you can see.

But basically through the "Startup..." button in Tools, I changed the view when you open the program so that you can't see any of the back end. I wanted to apply this to other users, but now when I log into the database, I only see the forms for viewing!!! I can't change ANYTHING.

Any suggestions? I'm in a huge bind. Until I get this fixed, I can't do anymore work....

~ E

 

[wazz]

try holding the shift key down when you dblclk to open the db file. hth.

 

[rubyred77]

That didn't work. I still have the logon screen I created and then all that opens are the forms I created....

 

[rubyred77]

Worked!

I did hold the Shift key down when I opened it, but what I was forgetting to do was hold it down again when I hit Enter after typing in my password.

I found the explanation here on the MS website:
"If you used the Startup dialog box (Tools menu) or created an AutoExec macro or an Open event procedure (event procedure: A procedure that is automatically executed in response to an event initiated by the user or program code, or that is triggered by the system.) to specify what happens when you open a Microsoft Access application, you can bypass those settings to regain full access to your Access file.

Hold down the Bypass key (the SHIFT key) while you open the database.
Depending on the macro security settings, you might see one or more security messages on startup. You must continue to keep the Bypass key pressed until you have closed the security messages.

Note You can disable the bypass key by writing a macro or Microsoft Visual Basic for Applications code that sets the AllowBypassKey property of the database to False."

 

[rubyred77]

Worked!

I did hold the Shift key down when I opened it, but what I was forgetting to do was hold it down again when I hit Enter after typing in my password.

I found the explanation here on the MS website:
"If you used the Startup dialog box (Tools menu) or created an AutoExec macro or an Open event procedure (event procedure: A procedure that is automatically executed in response to an event initiated by the user or program code, or that is triggered by the system.) to specify what happens when you open a Microsoft Access application, you can bypass those settings to regain full access to your Access file.

Hold down the Bypass key (the SHIFT key) while you open the database.
Depending on the macro security settings, you might see one or more security messages on startup. You must continue to keep the Bypass key pressed until you have closed the security messages.

Note You can disable the bypass key by writing a macro or Microsoft Visual Basic for Applications code that sets the AllowBypassKey property of the database to False."