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
help sometimes)

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
get bit.

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
administrator:

runcommand acCmdWorkgroupAdministrator

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
workgroup.

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.

Chris


Jacinda wrote:

How to split Front end/Back end
type mismatch and allowbypasskey
.mdb file is read only...
HELP!
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