secure the backend database

[gerard1979]

Can I put a password on the backend database?
Initutively I think the users can't read from the backend when I do this.

Maybe other ways to protect for looking by users in the backend data.
thnx in advance,
gerard

 

[KenReay]

Hi

This is a difficult one,

It depend how sophisticated your uses are, but ideas you might want to think about include:

Make the file (ie the backend.mdb) a hidden file

Put it on a hidden share

Hide the DbWindow of the Backend.mdb

Disable the allowbypasskey

but none of the above will stop a knowledgeable determined user.

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[FancyPrairie]

You can password protect the database, but I generally don't do it that way. I use the Security Wizard to secure the front-end and back-end databases. I create one or more group accounts and assign the appropriate rights to each group. The typical user group may have rights to read/write/delete/insert data in the tables but have no design rights. Note that you will need to define these rights to both the front and back-end databases.

After the group accounts have been setup, add users accounts. Then assign the user to whatever group you want them to belong to. I generally don't give any rights to the users. Rather, the group they belong to defines the rights they have.