How to removed security from Microsoft access

[Guest]

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

 

[Joseph Meehan]

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

I am not clear about what you are asking.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.

 

[Guest]

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

 

[Joseph Meehan]

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

Take a look at the properties of the shortcut he is using to open MS
Access. Try deleting everything after "Access.exe" on the target line.
Note: it would be wise to copy the shortcut and work on the copy not the
original. You can copy shortcuts from the start menu if needed.

 

[Joan Wild]

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.

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.

 

[Guest]

Joan:

What is workgroup administrator? how to run this?


Lillian

 

[Joan Wild]

Joan:

What is workgroup administrator? how to run this?

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.