Help! I Locked myself out of my database!

[Cole]

Hi everyone! I am having quite a scary problem. Yesterday I put about
16 hrs of work into creating a new front end file and ran the user
level security wizard. This caused me to have to enter a password
when I opened the file. Today when I have come into work, It tells me
I do not have the necessary permissions and does not give me the
option to even enter a password. The only thing I can think of is
that mabey when I logged off my roaming profile lost some file path or
something! I have a Security.mdw file that access generated in the
same folder as the frontend. I have fooled around trying to make a
shortcut to the file like "C:\Database\Frontend.mdb" /wrkgrp
"C:\Security.mdw" /user admin but without any luck. I have not used
any of access's built in security before so I am new to this problem.
Any help would be greatly appricated.

Thanks,
Cole

 

[Joan Wild]

Hi everyone! I am having quite a scary problem. Yesterday I put about
16 hrs of work into creating a new front end file and ran the user
level security wizard.

What version of Access?

This caused me to have to enter a password
when I opened the file.

How are you opening the file - via the desktop shortcut the wizard created?

Today when I have come into work, It tells me
I do not have the necessary permissions and does not give me the
option to even enter a password.

Then you are using the wrong workgroup (likely you are trying to open the
file via a double-click in Windows Explorer). Instead, use the desktop
shortcut.

I have a Security.mdw file that access generated in the
same folder as the frontend. I have fooled around trying to make a
shortcut to the file like "C:\Database\Frontend.mdb" /wrkgrp
"C:\Security.mdw" /user admin but without any luck.

The wizard usually creates a shortcut for you, but no problem to create one
of your own. You need to change the target (you almost had it) to include
the full path to msaccess.exe

"path to msaccess.exe" "C:\Database\Frontend.mdb" /wrkgrp "C:\Security.mdw"

Also you don't need to add the /user switch, but if you do you wouldn't log
in using the 'Admin' username, as this user should have no permission to
anything in the mdb.