Access Security Help!

[rhomer]

I have managed to lockup the entire Access program on my computer. I can get into, and make changes, to my database. BUT...I can't access any db's without logging into the Access program, not just an individual db. How do I undo my screwup? Or is it undoable and I end up having to save the db's, delete and reinstall Access and copy all the objects back.

 

[bjackson]

what access version are you using

 

[rhomer]

Access Security Help

I'm using Access 2002sr1

 

[ghudson]

Hopefully you have not altered your System.mdw file located at C:\Windows\System\System.mdw

If not, you need to rejoin your PC back to the generic System.mdw file.

If you have, you need to rename your altered System.mdw file and get a copy of the System.mdw file from another computer that is using the same operating system as yours and also the same version of Access. Then you need to rejoin your PC to the newly copied 'generic' System.mdw file.

I advise against 'joining' a PC to a specific security workgroup. That unnecessarily forces a user to log into the secured workgroup just to open any Access db's (new or old).

You should use a custom shortcut to open a secured db. The Target: field of the shortcut should look something like this to pass on the security info...
"C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp "X:\Testing\YourSecurityWorkgroupFile.mdw" "X:\Testing\DB.mdb" /user TestUser

HTH