Security on Access

MANDI201

Registered User.
Local time
Today, 03:17
Joined
Nov 21, 2002
Messages
15
Help.. I have somehow locked myself out of Access everytime I go to access a database it is now asking me to LOGON and give Password. I have never put password protection on My Access icon? I did try to put a security on a small database but I can access this via a colleagues "ID". Any suggestions as to how I can put this right?

Thanks for any help

MANDI
 
It depends what you really want to do. If you simply want to retrieve queries, reports, forms, modules, etc. Then the simple thing is to create a blank database, and then import all the necessary objects you need. Let me know if this is what you wanted to do or not, otherwise we can try something else.
 
Once you create a secured db on your computer (or open one for that matter) you join a different workgroup, secured.mdw, than the default workgroup. By using wrkgadm.exe you can rejoin your default workgroup which doesn't have security yet applied to it (that is if you didn't overwrite your default workgroup when you created the new one). If you did, no big deal, go to another computer running same version of Access with no security and copy secured.mdw over to yours, overwriting the "secured" copy.

Autoeng
 
Last edited:
Thanks

Thanks very much.... wont do that again in a hurry!
 

Users who are viewing this thread

Back
Top Bottom