Cannot Access Access

[Brendanpeek]

I set up Security on my Db using the user level security wizard. once the
wizard was finish and all passwords set up i restarted acces 2007 and put in
the username and password. this wasnt the problem, the problem was when i try
and creat a new Db it asks for a logon which i didnt want to happen plus when
i put in the user names and passwords i set up before, a message pops up
telling me the username and password are incorrect. i also cant remove the
security i have set up. so anyone that knows how to please help me

Thank you for your time.

 

[Joan Wild]

Access has changed the default mdw to the secure one you created. Use the
workgroup administrator to rejoin system.mdw (do a search for it first).
Once rejoined to system.mdw, you can use a desktop shortcut to launch your
secure mdb. All other sessions of Access will use the default system.mdw
and not prompt for a login. The target of the shortcut would look like...
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"

When entering the username/password, might you be confusing a password for a
PID - they aren't the same. Try a username with a blank/null password.

As for removing security, the wizard would have created a backup of your
mdb - look in the folder for a file with the same name but a bak extension
(just rename it to have a mdb extension).

 

[Brendanpeek]

Seach did not return any files

Access has changed the default mdw to the secure one you created. Use the
workgroup administrator to rejoin system.mdw (do a search for it first).
Once rejoined to system.mdw, you can use a desktop shortcut to launch your
secure mdb. All other sessions of Access will use the default system.mdw
and not prompt for a login. The target of the shortcut would look like...
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"

When entering the username/password, might you be confusing a password for a
PID - they aren't the same. Try a username with a blank/null password.

As for removing security, the wizard would have created a backup of your
mdb - look in the folder for a file with the same name but a bak extension
(just rename it to have a mdb extension).

 

[Brendanpeek]

and once i have found it how do i rejoin it

Access has changed the default mdw to the secure one you created. Use the
workgroup administrator to rejoin system.mdw (do a search for it first).
Once rejoined to system.mdw, you can use a desktop shortcut to launch your
secure mdb. All other sessions of Access will use the default system.mdw
and not prompt for a login. The target of the shortcut would look like...
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"

When entering the username/password, might you be confusing a password for a
PID - they aren't the same. Try a username with a blank/null password.

As for removing security, the wizard would have created a backup of your
mdb - look in the folder for a file with the same name but a bak extension
(just rename it to have a mdb extension).

 

[Joan Wild]

Be sure to include system and hidden folders in your search.
Hit Ctrl-G and type
Docmd.RunCommand acCmdWorkgroupAdministrator
By the way, when you ran the wizard, you created a new workgroup file,
right?

Otherwise you may have modified the standard system.mdw.