Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 stackoverflow.com Aug 31 '10 at 23:31

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

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

2 Answers

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
add comment

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
add comment

Your Answer

 
discard

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