2
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....
1
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.
mwolfe02
Posted 2010-08-30T07:30:01.550
Reputation: 445
To what end? How would this protect it? – David W. Fenton – 2010-08-30T20:50:03.533
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 – 2010-08-31T19:46:44.247
0
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.
user8841
Posted 2010-08-30T07:30:01.550
Reputation: 111
I am working wiht .mdb format..thats why i asked this question.. – None – 2010-08-30T13:19:29.273
-1
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.
Brad
Posted 2010-08-30T07:30:01.550
Reputation: 1
1
Sounds like a question for Super User, not here.
– Timwi – 2010-08-30T07:32:49.100What do you mean by "is not going to work". Is your db readable even if you set an access password on it? – None – 2010-08-30T07:38:24.287
Access passwords can be recovered easily ...... – None – 2010-08-30T13:18:28.103
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 – 2010-08-30T20:49:07.417
What is your goal? Keeping out the curious, controlling access to your application or actually protecting your data? – David W. Fenton – 2010-08-30T20:51:11.770
If you install SQL Server on your desktop, don't you still have access to the .mdf file? – JeffO – 2010-08-31T17:34:45.040