Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Geno
Starting Member
2 Posts |
 Posted - 2005-07-19 : 15:30:52
|
| Hello,I have a VB6 application that reads a MS Access database. I need to encrypt the database some way. I was wondering if someone knew the best approach. Do you have to encrypt the data on a field by field basis or is there a way to encrypt/decrypt the entire database at once? Or are there other ways?Thanks! |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-19 : 19:06:02
|
| Access has workgroup security that you can use to secure your database. Failing that, you can password protect the DB, but I wouldn't recommend it (it has a nasty habit of corrupting your DB). But before you try any of these options, be sure to take a backup. You could just encrypt individual fields using something like PGP or another encryption engine. Many of these are now available in reusable API's that you can hook into VB. Or you can encrypt the whole DB and only decrypt it when you want to use it. Depends on what the DB needs to do.HTH,Tim |
 |
|
|
|
|
|
encryption