Extracting data from Access Database password protected

A

Alex

I've manage to extract the data from a database into excel, however now the
database is password protected. How can incorporate the password into the
code I have now. I know the code should go somewhere in this area. Thanks
for any help

Set DB1 =
DBEngine.Workspaces(0).OpenDatabase("s:\Cio\Techplan\Adams\Itdmgmt\A_Proj_Mgmt_Rpt\Reporting\Access Databases\Dai_ITMB Access2000.mdb")
Set RS1 = DB1.OpenRecordset("tblFTSAtrakHrs", dbOpenTable)
 
J

Joel

Do a search in VBA help for "opendatabase". Look at Opendatabase Method
(DAO). the last parameter CONNECT can contain a 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

How to bypass password when pasting FROM a protected workbook 3
Exporting data with vba from Excel to an Access 2007 db with password 8
Linking Tables from Password Protected DB 1
Populate Userform Listbox with Access values 5
getObject and password protected workbook 4
Open password protected database 2
Retrieve data from encrypted Access 1
locad password protected MS Access table 0

Top