Question Securing a Backend Database

[matthewnsarah07]

I currently have 6 holiday databases that have their own tables - I am going to move all the table into one Backend database and use link tables in the 6 front ends.

My question - how do I keep the BackEnd as secure as possible - obviously simple passwords won't work as I assume they would be requested everytime someone tries to add a record.

What does anyone recommend

Thanks for your help

 

[matthewnsarah07]

Still needing some guidance on this one if anyone can assist at all?

 

[DJkarl]

I've used a database password to protect the backend before, I just had the code on the front end relink the tables as needed using the password.

 

[Len Boorman]

You could use ASccess Security but do not just run the wizard unless you know what you are doing.


I have some papers about security if you are interested. They are principly Access 97 based but all the details follow through.

I cannot post them here they are too large. PM me with an email address and I will send them.

Len

 

[matthewnsarah07]

Going to DJ's comment - what code do I need in the Front end in order to link the tables with a password protected backend.

Thanks