Re: Cannot Access Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



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
Microsoft Access MVP
"Brendanpeek" <Brendanpeek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:08FD13DD-19B9-42C6-9822-C699B53C082F@xxxxxxxxxxxxxxxx
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.

.



Relevant Pages

  • Re: Cannot Access Access
    ... "Joan Wild" wrote: ... workgroup administrator to rejoin system.mdw. ... secure mdb. ... Try a username with a blank/null password. ...
    (microsoft.public.access.security)
  • Re: Cannot Access Access
    ... "Joan Wild" wrote: ... workgroup administrator to rejoin system.mdw. ... secure mdb. ... Try a username with a blank/null password. ...
    (microsoft.public.access.security)
  • Re: Connection to Access Database Problem
    ... UserName & Password are OK as I have to enter them when I open ... Originally the mdb didn't have any userid/password set (which is how I had ... I've just deleted the above connection and tried setting up a new one. ... Like it isn't even looking at the database. ...
    (borland.public.delphi.database.ado)
  • Re: Wachovias web page security
    ... Note the URL displayed on the error message. ... that the page is secure. ... The only difference is that on my web page when you enter your username ...
    (misc.consumers)
  • Re: Connection to Access Database Problem
    ... UserName & Password are OK as I have to enter them when I ... Originally the mdb didn't have any userid/password set (which is how I ... Like it isn't even looking at the database. ... database - one copy is in the wwwroot folder the project files are in ...
    (borland.public.delphi.database.ado)