Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

After installing my desktop application any body can see the database on their local systems. Even if I set Password security on access database its not going to work.Encryprion may be one of the good technique of accomplishing this task ,i think...Please suggest....

share|improve this question

migrated from Aug 31 '10 at 23:31

This question came from our site for professional and enthusiast programmers.

Sounds like a question for Super User, not here. – Timwi Aug 30 '10 at 7:32
What do you mean by "is not going to work". Is your db readable even if you set an access password on it? – mamoo Aug 30 '10 at 7:38
Access passwords can be recovered easily ...... – Ripper Aug 30 '10 at 13:18
Access database passwords are not nearly as easily recovered in A2007 and A2010 as they used to be, because A2007 greatly increased the encryption level (and how it was stored). That said, database passwords are basically "security theater" not real security. If you need actual data security, you shouldn't be using a file-based datastore, but a server database engine like SQL Server or MySQL instead. – David W. Fenton Aug 30 '10 at 20:49
What is your goal? Keeping out the curious, controlling access to your application or actually protecting your data? – David W. Fenton Aug 30 '10 at 20:51

Since an .mdb is simply a file, you could use third-party software (such as the free and excellent TrueCrypt) to encrypt the file itself.

share|improve this answer
To what end? How would this protect it? – David W. Fenton Aug 30 '10 at 20:50
It would protect it from an unauthorized user who has access to the mdb, five minutes of free time, and an internet connection to download an MS Access password cracker/recovery utility. – mwolfe02 Aug 31 '10 at 19:46

For Access 2007, if you use the ACCDB database format and password protect your DB, which will automatically encrypt it. I don't know about older versions of Access, but see this tutorial for Access 2007.

share|improve this answer
I am working wiht .mdb format..thats why i asked this question.. – Ripper Aug 30 '10 at 13:19

I know this is a really old thread, but other may come across it. While Access 2003 security would allow user groups etc to be set up, as mentioned above, it could still be hacked. Perhaps a better method would be to get your IT to set up a folder where only your user login had access to it, thereby preventing other users on the network from getting into the folder and seeing he files.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.