Posted on 1998-07-31
Access97. I want to deploy a database and prevent users from using the shift key when opening the database. The AllowByPasskey property will do this. But I can't figure out how to do it. The notes I have state:
The AllowByPasskey Property can only be set from code, and should be set to false. However, a backdoor to the database can be enabled, by using the /cmd option on a command line. for example:
c:\my documents\msaccess.exe test.mdb /cmd AllowShift
The example above, the command line passes the phrase AllowShift to the Access Command() function. Add code to the application's startup form to check for the special string (AllowShift) in the Command() function and set the AllowByPasskey property to True if the string is found. A developer can then reopen the unlocked application while holding down the shift, which will provide access to built in menus etc.
How do I do this??
any ideas. please provide code etc.