Database Password Only

[Rita]

I have a database that will only be used by two people as
it contains confidential information. It is on a network
drive so we can both get to it any time. Both people will
need full access to the database, so I only need a
password for the entire database not user-level security.
I set a password and when I open the database it only asks
for a password. When my co-worker tries to open the
database, it asks her for a logon name and password. I do
not know what the name is so she cannot open it. The Help
menus do not say anything about this situation, so I do
not know what to do but need to leave the database secure
because it is confidential. The co-worker cannot get in at
this point. I would greatly appreciate any help.

 

[Lynn Trapp]

It sounds like your co-worker is joined to a secure workgroup that is
prompting her for the user name and password. Have her use the workgroup
administrator and join the system.mdw file that was installed with Access.

 

[Joan Wild]

You co-worker's computer is joined to a workgroup that has a password set
for the Admin user.

Do a search on their computer for *.mdw and make a note of the paths.

Run the workgroup administrator (Tools, security menu in 2002/2003, Start -
Run- wrkgadm.exe in prior versions) to see which one they are joined to
currently. Try joining the standard system.mdw workgroup (usually located
in the windows system folder).