MSysModules2 - Shift key to bypass startup settings

[Michael Allen]

We have a secured Access 97 database application.

I have used Jamie Czernick's Access Prooerty Editor 97 to prevent the use of
the Shift key to bypass the Startup settings. This works fine with an mdb
file.

However when I make the mde file I am unable to allow permissions to the
MSysModules2 since I have locked myself out by not allowing bypassing of the
startup settings (I have not allowed display of the Database Window).

Is there any way that permissions to MSysModules2 can be set before making
the mde file.

Regards,
Mike

 

[Joan Wild]

You just need to change the order you do things in.

Create the mde
Set permissions on MSysModules2
then disable the shiftkey bypass in the mde.

(not familiar with Jamie's utility), but it should work. If it can't work
with a mde, then just change the extension to mdb to fool it.

 

[TC]

You can /always/ get back in, as long as you still have (or can
recreate) the workgroup file with which you created the database.

Just log on to Access as a member of the Admins group of that workgroup
file, then run the following code:

(untested)

dim db as database
set db = dbengine.opendatabase("full path to the locked database")
db.properties.delete "AllowBypassKey"
set db = nothing

You could add some error handling if desired.

HTH,
TC