Securing a database

[Mechele]

I have a database with only one user. The information the user is entering is very confidential. Also, the database has to be stored on our network.

Can someone tell me how to set up security for only one user and myself as a administrator in the simpliest terms. I have tried to follow the instructions in my book and I lock myself out of my own database every time. Also, how do I keep people from using the shift key when opening the database to get access to it from the back end?

 

[dbalargin]

Shift key problem: do a search for "shift key". you'll get a lot of examples

 

[Autoeng]

Security is very difficult thing to implement. Read the Security Faq's. http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp Read it cover to cover then start.

However, as you are not in a multi-user environ you might be better served with only placing a password on the db. Search in Access help for "Protect a database by adding a database password".

 

[ghudson]

IMHO...

The best security (and easiest for you) would be to have your network admins secure the folder that the db is located in on your network so that only that one person (and you if you need to modify the db design) can access the files (db) within that network folder. That person (and you) will need to have read/write/delete file access to the secured folder.

That will prevent any unauthorized users from even touching the db file.

HTH