Secure backend database 1

[honeypot3]

Hi there

This is a fairly basic question but I am going round and round in circles with it. I have a database that has been split. The original MDB file had user level security set up on it which has been pulled through fine into the front end but the backend is now easily openable by double clicking on it through Explorer, obviously leaving the data open to other users. I have tried password protecting the backend file but then the front end cannot work properly with it as it needs the password when executing queries etc. Please advise - at the moment both backend and front end are stored in the same folder as users access the database via shortcuts. Thanks

 

[Ed2020]

Honeypot,

This is a bit of a cheat, but if you are sure the frontend is properly secured and the backend is unsecured the easiest way would be to:

1. Take a copy of the frontend database.

2. Delete all objects from the copy leaving a blank but secured MDB file.

3. Import all the tables from your current unsecured backend.

4. Open the frontend and relink all the tables from the new secured backend.

Like I said - it's a cheat but it is a quick and easy way of ensuring the security is set consistantly on your frontend and backend database files.

Note - This will only work if you have set the permissions for all new database objects correctly. Also make sure that the Admin user in your MDW file is crippled by removing all rights and putting a password on it.

Ed Metcalfe.

Please do not feed the trolls.....

 

[alvechurchdata]

the front end cannot work properly with it as it needs the password

I don't see this problem when I use this technique.

If I link the backend table in by hand then I get asked for the password when I design the database. If I link the backend table in with DAO code then I pass the pwd parameter across. Either way, the user doesn't get asked for the password.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[honeypot3]

Hi Ed

Thanks for that it works like a dream - you are a real star!!