open Access DB that is password protected

S

Shin

I have the following code written in Excel VBA to open an
Access DB:

Set db = OpenDatabase("I:\test.mdb")

However, the DB is password protected. Is there anyway I
can write code to open the DB in the background? I know
how to do this for Excel but can't figure out how to do
it for Access.
 

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

Exporting data with vba from Excel to an Access 2007 db with password 8
How do I clear a form? 0
Password protect new workbooks from template 0
OpenDatabase recommended practise 0
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Excel VBA to delete records in Access table and reset the Autonumber 1
Protected word template - vb/macro to update footer 7
How to bypass password when pasting FROM a protected workbook 3

Top