back end database security

[paul]

Hi,
In my Access 2000 application, I split the system into
front end (fe) & back end (be), copied the fe to each
user's machine, and put the be file in the server.
How to protect my be file? I don't want to put password
(my previous application, when be file crashed, I couln't
repair).
Thanks a lot.

 

[Rick B]

To protect any database, back or front, you should be using Acess' built in
User Level Security.

This will force users to log in when they open your database and will edit
their permissions based on your setup.

Rick B

Hi,
In my Access 2000 application, I split the system into
front end (fe) & back end (be), copied the fe to each
user's machine, and put the be file in the server.
How to protect my be file? I don't want to put password
(my previous application, when be file crashed, I couln't
repair).
Thanks a lot.