Encrypt/decrypt

[TeeVee]

Hei,

Is it possible to encrypt/decrypt an Access db-be with a password supplied by the developper?
I know that access can encrypt/decrypt but that is using a standard used by all and every access installation. So that is no protection on a PC with access installed.
Regards
TV

 

[HiTechCoach]

I know that access can encrypt/decrypt but that is using a standard used by all and every access installation. So that is no protection on a PC with access installed.

I am not sure if that is really true. Where did you here that?

 

[Guus2005]

You can secure the database using a password. However, the data will not be encrypted.
To encrypt the data you need to encrypt each value yourself. You can use the MD5.DLL (or RSA, ... ) to encrypt each value individually.

HTH

 

[TeeVee]

Thanks for the replies.
I can encrypt the DB with Access standard function and yes the db will be encrypted (checked it).
But at least on the same pc ms-access uses the same encrypt/decrypt key for all applications because i can link any encrypted table without any problem reading the data within any other access application.
But it could be that access uses an different encrypting key on each pc, i have not checked that yet, but that makes distributing a, by access encrypted db not possible and so not useable. So i donot think that will be the case.
With any encrypting/decrypting the developper should be able to specify the encrypting/decrypting key by yourself through VBA.
But newer versions might have more and better functions, i don't know i use ms-access2000.
Or are there any vba functions to interfere with the encrypting/decrypting function and so supply your own key.
I assume that the remaining possibility is to include a separate encrypting/decrypting tool as suggested.
regards
TV