back end tables not secure

[MelB]

This is my first experience with Access Security. The Security was built and applied before the database was split using the wizard. I have moved the back end data to the LAN and plan to put the front end and the mdw file on each individuals PC. This doesn't seem to work because I just checked and I can directly open the back end on the LAN and don't get prompted for a login ID. Do I need to put the mdw file on the LAN also? What did I do wrong? How should this be done?

 

[RichMorrison]

Yes, you need to put the MDW on a shared drive on your LAN.

The reason you opened the back end without getting a login box is probably because you have a system.MDW on your local drive. This causes Access to log you in as the default "User" person.

To secure the back end on the server you should:
1) Put a system.MDW on your LAN. It should contain the appropriate Groups and Users.
2) Launch Access using the system.MDW on the LAN; use an ID and password with Admin rights
3) Create an empty MDB on your LAN
4) Import your data tables
5) Set appropriate permissions for groups to tables

When this is done, the back end MDB is now secured. You can still open it without the LAN system.MDW, but you won't have any permissions.

RichM