Board index » delphi » Using ADO with Encrypted/Password Protected Access databases

Egdif

Delphi Developer
Sun, 28 Sep 2003 20:15:28 GMT

Using ADO with Encrypted/Password Protected Access databases

Hi All,
    I'm having a little trouble using TADOConnection with an encrypted and
password protected Access 2000 database. I've set the UserName and Password
string variables correctly in the TADOConnection.OnLogin event handler, but
get an error stating "Not a valid password".

Is there maybe a provider specific property or another mechanism for giving
the correct database-wide password?

Also, I'm a bit baffled about the encryption. Am I right in assuming that
all fields values are encrypted when stored and decrypted when retrieved
(on-the-fly), or is the encryption process a "one-off" process as with
compacting a database?

Thanks,
Ben Fidge

 
M.H. Avegaar

Delphi Developer
Sun, 28 Sep 2003 21:05:45 GMT

Re:Using ADO with Encrypted/Password Protected Access databases


OnLogin is executed AFTER log-in and can be used to do user logging.
You should use the OnWillConnect event instead !

"Egdif" <ben.fi...@stylusnet.com> schreef in bericht
news:5XXA6.11446$s02.21006@NewsReader...

Quote
> Hi All,
>     I'm having a little trouble using TADOConnection with an encrypted and
> password protected Access 2000 database. I've set the UserName and
Password
> string variables correctly in the TADOConnection.OnLogin event handler,
but
> get an error stating "Not a valid password".

> Is there maybe a provider specific property or another mechanism for
giving
> the correct database-wide password?

> Also, I'm a bit baffled about the encryption. Am I right in assuming that
> all fields values are encrypted when stored and decrypted when retrieved
> (on-the-fly), or is the encryption process a "one-off" process as with
> compacting a database?

> Thanks,
> Ben Fidge

Other Threads

1. accessing a password-protected Access Database using ADO

2. BDE Encrypted Access 97 Database Password

3. D4 reading encrypted / password protected dbase7 tables

4. How to connect to a password protected Access Database

5. Writing to a password protected Access database?

6. How do I password protect an access database?

7. General SQL Error - Delphi 5/Access - Password protected Database

8. General SQL Error - Delphi 5/Access - Password protected Database

9. Login to a password-protected Access database

10. using encrypted access database