Access asking for password on one machine

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike M - 19 Sep 2003 18:32 GMT

Access has started prompting one of our users for a PW everytime she
opens a Database. Any DB all DB's. But no security has been applied and
now passwords set. She just hits enter or cancel and the DB opens!
What has happened?

Signature

Mike Moore
Computer Services Technician
Snow Summit Mt. Resort
Office (909) 866-5766 Ext.270
mikemoore@ www.snowsummit.com
Contact info not for share, rent or distribution.

Reply to this Message

Joan Wild - 21 Sep 2003 17:10 GMT

Her computer is joined to a workgroup file that has a password set for the
Admin user.

Use workgroup administrator (Tools, security menu in 2002; Start, Run,
wrkgadm.exe in 2000/97) to see what mdw is the default. Then click on
'Join' and join the standard system.mdw that ships with Access - usually
located in Windows system folder.

Signature

Joan Wild
Microsoft Access MVP

> Access has started prompting one of our users for a PW everytime she
> opens a Database. Any DB all DB's. But no security has been applied and
> now passwords set. She just hits enter or cancel and the DB opens!
> What has happened?

Reply to this Message

Mike M - 22 Sep 2003 16:14 GMT

Thanks Joan I will have a look.
I do not remember setting any passwords on this file though.

| Her computer is joined to a workgroup file that has a password set for the
| Admin user.
[quoted text clipped - 8 lines]
| > now passwords set. She just hits enter or cancel and the DB opens!
| > What has happened?

Reply to this Message

Joan Wild - 22 Sep 2003 16:26 GMT

You may not have set any passwords on the file. But perhaps the user
'played' with the settings in Tools, Security menu.

In fact, it's possible that they modified the default system.mdw workgroup
file. If you search their computer for *.mdw and find there is only one,
then depending on version, you can:

1. If 2002, rename the system.mdw, and open Access - it will create a new
system.mdw
2. If 97/2000, copy system.mdw from another computer and put it in the
windows system folder.

Signature

Joan Wild
Microsoft Access MVP

> Thanks Joan I will have a look.
> I do not remember setting any passwords on this file though.

Reply to this Message

Mike M - 22 Sep 2003 22:20 GMT

Well something had changed. I checked her tools menu and found her as a
user when she was originally an Admin. I added Admin to her profile and
she is all good now.
At least until wee implement some security that is.
Thanks again Joan.
Mike

| You may not have set any passwords on the file. But perhaps the user
| 'played' with the settings in Tools, Security menu.
[quoted text clipped - 10 lines]
| > Thanks Joan I will have a look.
| > I do not remember setting any passwords on this file though.

Reply to this Message