I can see that I'm not the only one who has done this...
I was trying to set security on a user level... I was using Access 2007
(which is just confusing anyway... I wish Microsoft would just stop trying to
Anyway... It has locked me out.
I don't think there is a back up, because when it started going through the
steps it froze and kicked me out....
So am I starting from scratch now?
Don't panic. It happens a lot. Nobody reads instructions until *after* they
Look for the backup file in the same folder as your db. Probably named
something like filename.bak. Change it to filename.mdb and try to open it.
If you're locked out do these steps:
1 - Search your hard drive for system.mdw. It's probably stored at C:\
Documents and Settings\username\Application Data\Microsoft\Access\system.mdw
2 - Open Access (not a db file, just Access)
3 - Push ctrl + G to open the immediate window
4 - Paste this line in the window and push enter to open the Workgroup
5 - Push the "join" button
6 - Browse to your system.mdw file you located in your search
7 - Push the ok button (3 times to accept each message)
8 - Close Access
Now you shouldn't be prompted for user name and password when opening dbs
unless you accidentally added a password to the admin user in the default
If you don't already have one created by the security wizard, make a shortcut
to your secure db:
"path to msaccess.exe" "path to db.mdb" /wrkgrp "path to secure.mdw"
Whenever you want to open an unsecure db, you double click the file name in
Windows Explorer and it opens. Whenever you want to open a secure db, you
double click the shortcut to it (so you temporarily join the secure workgroup
for your session), and you'll be prompted for user name and password.
>I can see that I'm not the only one who has done this...
>I was trying to set security on a user level... I was using Access 2007
>(which is just confusing anyway... I wish Microsoft would just stop trying to
>Anyway... It has locked me out.
>I don't think there is a back up, because when it started going through the
>steps it froze and kicked me out....
>So am I starting from scratch now?
Message posted via http://www.accessmonster.com
Other interesting topics
How to split Front end/Back end
type mismatch and allowbypasskey
.mdb file is read only...
Shortcut needs to work in a Domain instead of a workgroup
I cannot open a DB created by another user on my PC.
Access cannot open file on stand alone computer
help understanding mdw files!
AllowBypassKey and Type Mismatch Error
I have Idea for solving problem the security for files by using