Encrypting a database

[RichardMGreen]

Hi all

I've been making enquiries on the Excel board (http://www.mrexcel.com/forum/showthread.php?t=550524) regarding running queries from Excel on a database with password protection.

I've got that bit sorted but now I need to know about database encryption.

If you look at post #13, I've come a bit unstuck.
Because of what the database contains, I need to encrypt it. That gives me 3 questions:-

1) What's the best way of encrypting the database to keep the information at least reasonably secure?
2) Will my code on the other thread still work with an encrypted database?
3) If it won't, how would I modify it so that it does?

There is an option in Tools/Security to Encode/Decode the database but it would appear I need Workgroup administration for that.

Can someone please explain the best way to encrypt the database while still allowing Excel to run the queries and return the data?

All help greatly appreciated.

 

[SydneyGeek]

Richard,

To encrypt...
http://www.developer.com/tech/article.php/724731/Encrypting-an-Access-Database.htm

to connect to the encrypted DB...
http://www.utteraccess.com/forum/lofiversion/index.php/t1965915.html

Hope that helps
Denis

 

[RichardMGreen]

Hi Denis

Thanks for that, looks like I can just go ahead and encrypt it.
I'll give a try on a copy of the database and see what happens.

Thanks again.