How to removed security from Microsoft access

L

Lillian

I have one user, every time he try to open mdb file, alway ask him the user
name and password, the user told me if he gave any mdb file to his co-worker,
they all can open file without any problem, only him.

Any idea, need help. thanks.


Lillian
 
L

Lillian

Joseph:

I alraday went to the side you gave to me, and I did not find the answer I
need it. example: when user open northwind.mdb file, the screen pop up
username:
password:
anyboday can open this file, but him, if I open access, then from the top of
tools-->security--> user group and account--> then I see user, group, change
logon password on the form for the regular user, but this user did not have
those, his popup form like: username;
password:
without enter those information, he can not open any mdb file, is any way I
can removed this security, I know user screw up something on his PC, but
don't know where, need help

thanks.


Lillian
 
J

Joan Wild

Lillian said:
I have one user, every time he try to open mdb file, alway ask him
the user name and password, the user told me if he gave any mdb file
to his co-worker, they all can open file without any problem, only
him.
Click to expand...

This user is joined by default to a workgroup file that has a password set
for the 'Admin' user. Every session of Access uses a workgroup file.
System.mdw ships with Access and is used by default - it silently logs you
in as 'Admin'.

You can change the default to some other workgroup file (which may be what
this user did).

Start by searching for all *.mdw files on his computer. Then use the
workgroup administrator (Tools, Security menu in Access) to see which one
he's joined to by default. Click on Join and rejoin the standard
system.mdw - it's usually found in the windows system folder, but you'd find
it in your search above.

If he has only one mdw on his computer, or he's already joined to
system.mdw, then post back with the Access version.
 
J

Joan Wild

Lillian said:
Joan:

What is workgroup administrator? how to run this?
Click to expand...

As I said it's in the Tools, Security menu in Access. You didn't mention
the version of Access you are using so I assumed it was 2002 or 2003. If
you are using an earlier version, then go to Start, Run, and type
wrkgadm.exe.
 
Top