Encrypt/Decrypt Access 2000 .mdb file (for use with VB app)

[David Laplante]

I've seen many discussion going around this question without seeing one actually answering it. What I have is a VB application, using DAO to read an Access 2000 .mdb file. I would like to know how to encrypt my database files so that only my vb app can access its content.

It's not for preventing users to do unwanted changes to the DB, it's for avoiding users to steal my DB's content (said that way to make it clear). I don't want my data to be accessed by anyone, at any cost because it contains confidential information. Since a password can be cracked, i'm not interested in that solution. Making the .mdb files invisible is an idea, but not a solution.

Thanks for the help.

[MrShickadance]

What you are going to have to do is come up with an encryption/decryption algorithm. This is not an easy task esp. if you need something as secure as say blowfish. There probably is an OCX out there which will encrypt/decrypt files, but I don't know of one off hand. I think vb-world has a simple en/de crypting algorithm.

[Chris]

You can encrypt your database when you compacting the database.
[code]
DBEngine.CompactDatabase OldDb, NewDb, dbLangGeneral, dbEncrypt
[/code

[Chris]

You can encrypt your database when you compacting the database.

DBEngine.CompactDatabase OldDb, NewDb, dbLangGeneral, dbEncrypt

[David Laplante]

I tried that, but encrypting the database won't make the data innacessible or not viewable. Have you ever triee it by yourself?

Thanks.

[David Laplante]

Any other suggestions?