i can't edit my access ! i've locked myself out 1

[chaft]

help!

i changed the startup options so that I could hide the access menus.
Then I compacted and repaired the file and now I cannot edit the access database. I still need to fix it! What do I do now? I need to be able to design!

heeelp

 

[jrbarnett]

Open the database
Press F11 to open the database window
Press Ctrl G to open the debugger
In the immediate window of the debugger, type

DoCmd.RunCommand acCmdStartupOptions <ENTER>

This will open the startup options screen to allow you to reverse the changes you made.

John

 

[chaft]

Thanks for you quick reply

Everything worked accept that code in the immdediate window. I don't know why. I read another thread in TEK TIPS and discovered that by holding tab I can bypass the startup options.

thank god that worked..would had still liked your code to had worked though..any ideas why it didn't?

 

[jrbarnett]

Funny, it works here (Access XP SP3 on WinXP Pro SP2). Which version of Access are you running?

My understanding was that holding down the shift key (rather than tab) would bypass startup options, but never mind.
The only time this wouldn't work is if the developer has set the AllowBypassKey property to false in their code, but this can't be set from the Access user interface.

John

 

[chaft]

access 2002. winxp pro sp2

 

[irishjoe]

I've just checked my version 2002 and XP and if you click on the access file, then hold down shift then press enter, it should bypass the onload bits.