How do I apply security to two db's using the same secure mdw?

[Eric]

Hi,

I have two databases, a front end and back end. I have
gone through and set security on the frontend so that the
database can't be accessed with the standard system.mdw
file. This works great, just as it should. My question
is can I give the backend database the same security
without creating a new secure mdw file for that database.
I have tried and I can apply the security if I open the
backend database with the special link I created, but for
the backend db I can still open it with the standard
system.mdw when I don't use the link. Is it possible to
do this? Thanks in advance,

Eric

 

[Joan Wild]

Hi,

I have two databases, a front end and back end. I have
gone through and set security on the frontend so that the
database can't be accessed with the standard system.mdw
file. This works great, just as it should. My question
is can I give the backend database the same security
without creating a new secure mdw file for that database.
I have tried and I can apply the security if I open the
backend database with the special link I created, but for
the backend db I can still open it with the standard
system.mdw when I don't use the link. Is it possible to
do this? Thanks in advance,

Use the workgroup administrator to join your secure mdw - Tools, security,
workgroup administrator. Open Access and create a new mdb, logging in as a
user you want to own the database. Import all the objects from your
backend.

Then apply the security you want, ensuring you remove permissions for the
Admin user and the Users group (don't forget the database object).

Once you are done, rejoin the standard system.mdw.

Open your frontend and refresh the links to the backend, and test.