updates

[jamesday67]

:eek: How about using the power archiver for encrypting and compessing databases. Would this require every file in the database to be encrypted and or is it even possible because the data in the database would be encrypted and could not be read or accessed without the password on each file. :rolleyes:

[mwb1100]

Regardless of encryption, the files in the archive would have to be extracted for the database application to be able to use them.

If you want to have a database application use files that are encrypted, take a look at TrueCrypt:

http://www.truecrypt.org

However, using TrueCrypt does not buy you any compression. Also, you need to be aware that the database application may store data temporarily in an unencrypted state, so that may be an issue need you to deal with.

[jamesday67]

For a test I encrypted a .mdb access database file and it worked I was able to encrypt the file without extracting the files…. So it just password protected the database it seems… :rolleyes:

[spwolf]

@jamesday67:

For a test I encrypted a .mdb access database file and it worked I was able to encrypt the file without extracting the files…. So it just password protected the database it seems… :rolleyes:

well is it an active database or are you backing it up?
For backup purposes, yes, you can do it.

However, if this is an active database that has to be accessed as .mdb file in realtime, then you cant used PA and you should use either MS Access encryption or some encryption tool that tries to transparently handle this.

If you need really secure solution, then you should use database that already had safe encryption built in.

thanks,