Retrieve data from encrypted Access

L

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.
 
G

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.
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update MySQL database using Excel VBA 1
Extract data from XML file and populate them into cells 1
Access query(with custom function) from Excel 3
Unzip all encrypted files in a folder with known passwords 7
Retrieve data from Access database and fill data in form 0
Passing data to an event handler 3
Link, drop link, relink 2
Pulling data from one workbook to another one using VBA 0

Top