All my databases now expect a password

[Stapes]

Hi

I have set up a database for a client that required restricted access,
with the use of user names & passwords. For this, I created a
dedicated work group file and set it up that way. Everything has been
working fine, including the customers copy. Now, I have come to make
some changes to it - including splitting the database into a front end
and a back end.

Now, all the databases on my PC are asking me for a user name &
password - it was only intended for the one. What has happened here &
how can I put it right?

Stapes

 

[Rick A.B.]

Hi

I have set up a database for a client that required restricted access,
with the use of user names & passwords. For this, I created a
dedicated work group file and set it up that way. Everything has been
working fine, including the customers copy. Now, I have come to make
some changes to it - including splitting the database into a front end
and a back end.

Now, all the databases on my PC are asking me for a user name &
password - it was only intended for the one. What has happened here &
how can I put it right?

Stapes

Stapes,

It's doing this because you've connected access to the .mdw file you
created instead of pointing to the .mdw in the shortcut to the data
base. You will need to reconnect access to the default System.mdw
that comes with access and then reference the security file you
created in your shortcut to your database like this.

"C:\Program Files\Microsoft Office\Office11 MSACCESS.EXE" "N:\database
\AviationCenter.mdb" /WRKGRP "n:\Student\data\Secured.mdw"

I can't remeber where the system.mdw workgroup file is located but if
you seach for system.mdw you should find it. Hope that helps.

 

[Guest]

In addition to rick's reply if you've overwritten the original system.mdw you
can just copy that from another pc and place it in the original designated
directory.