Reverse RunTime Startup or ByPass in Access 2000 1

[jofarrell]

I have an Access 97 database that starts up as an application upon opening. In Access 97 I can by pass this by hitting shift while opening, is there a way I can either a) reverse the "start in runtime mode" in Access 97 (having gone under Tools - Startup and removed begining form as well as chosing full menus), OR b) By pass the runtime mode in Access 2000 in the same way that the shift while opening works for 97 as it doesnt seem to work there?

Thank you in advance for your help.

 

[jofarrell]

If the exact way to do this isn't known, has anyone even heard that the capability exits to undo application startup or another way to shift open in Access 2000?

Any information would be appreciated,

Joanne

 

[RickSpr]

Look up the AllowBypassKey property in the help file. Apparently it's set to False for your database. You need to change it to True to allow the Shift key to work. This will apply to all users.

If you've already locked yourself out, you may or may not be able to get back in. It depends on whether you're using the standard File menu. If you are, open Access without specifying a database. Then choose the database you want to open from the File menu. The second time you do this, it will open to the database window.

If you've locked yourself out and you're not using the standard File menu, you'll have to open another database and write a routine to open the locked database as a second database (using OpenDatabase). Then, using the object variable representing the second database, change the AllowBypassKey property to True.

If you're looking for a way to create a "backdoor", try creating an AutoKeys macro. Select the key combination you want to use, and set the macro action to SelectObject, setting In Database Window to Yes. Or, you can use your backdoor to re-arm the F11 key by changing the AllowSpecialKeys property.

Another backdoor way would be to have your startup form check the value of the command line (use the Command() function) for a secret word. Then start your database with a custom shortcut containing "/cmd secretword" at the end of the Target field. If the form finds the secret word, it can show the database window or allow special keys as above. Rick Sprague

 

[RickSpr]

By the way, you should probably modify your startup code anyway, so that Administrators can get to the database window and standard menus. Rick Sprague

 

[jofarrell]

I will try that and see if it works, thank you for the advice.

Joanne