DB Security

[systematic]

Hi all,

Just looking for a little advice on data protection. I have a split database which is accessed from the front end (forms only). All data is stored on the back end, which is hidden away from the user.

The database is password protected, and both sides use a login authentication to avoid unwanted access. However, the usernames and passwords are easily retrievable by opening the database a text document.

Any ideas on how to make this more secure?

Cheers

sys

 

[ghudson]

Use Access security with workgroups and user permissions. Search around for there are a few thousand postings related to the subject. Ensure you understand what you are doing before you try to secure your db. Also, backup your db before, during and after you attempt to secure it for you can lock yourself out if you flub it up.