Cannot Access Access

  • Thread starter Thread starter Brendanpeek
  • Start date Start date
B

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.
 
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).
 
Seach did not return any files

Joan Wild said:
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).
Click to expand...
 
and once i have found it how do i rejoin it

Joan Wild said:
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).
Click to expand...
 
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.
 
Back
Top