up vote 2 down vote favorite
share [g+] share [fb]

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....

link|improve this question
1  
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
show 1 more comment
feedback

migrated from stackoverflow.com Aug 31 '10 at 23:31

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

3 Answers

up vote 1 down vote

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.

link|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
feedback
up vote 0 down vote

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.

link|improve this answer
I am working wiht .mdb format..thats why i asked this question.. – Ripper Aug 30 '10 at 13:19
feedback
up vote 0 down vote

See here.

link|improve this answer
Microsoft Access can still open and read the file. – Jeff O Aug 30 '10 at 17:34
@Jeff O: the file would not be of much use if Access could not, no? – David W. Fenton Aug 30 '10 at 20:50
@David-W-Fenton - maybe something with a less-crackable password would be nice like v 2007+. – Jeff O Aug 31 '10 at 17:31
feedback

Your Answer

 
or
required, but never shown
discard