Retrieve data from encrypted Access

[Lane]

Dear Excel gurus,

I am not sure if I should address this question to Excel or Access
experts. Sorry if I posted on the wrong group.

I would like to know if Excel can extract data from an encrypted
Access database using VBA. The VBA programmer knows the Access
password. Has anyone tried this before? Thank you very much. I have
successfully done so on an unencrypted database but cannot find useful
information on the internet if the database is encrypted.

 

[GS]

Lane pretended :

Dear Excel gurus,

I am not sure if I should address this question to Excel or Access
experts. Sorry if I posted on the wrong group.

I would like to know if Excel can extract data from an encrypted
Access database using VBA. The VBA programmer knows the Access
password. Has anyone tried this before? Thank you very much. I have
successfully done so on an unencrypted database but cannot find useful
information on the internet if the database is encrypted.

Yes, you do it by including the password in the connection string
(assumes using ADODB). Just google "database connection string
password".