Access to Access ODBC Connection

[szymon_k]

How to connect one MS Access database to another password protected
(database password) database so that to have an access to the tables
only from VBA. I don't want them to be linked and visible in the
database, but i would like to get data from this external tables only
from the code.
Szymon.

 

[Guest]

It's been a while, but try the following.

....
Dim strDatabase as String
Dim strPassword as String

Dim dbData As DAO.Database
Dim ws As DAO.Workspace

strDatabase = "c:\my folder\database.mdb"
strPassword = "MyPassword"

Set ws = DBEngine.Workspaces(0)
Set dbData = ws.OpenDatabase(strDatabase, , , ";Pwd=" & strPassword)
....

Hope this helps.

 

[szymon_k]

Thank's
It should work, but I get "Invalid Password" error...

 

[Guest]

Try it with:

Set dbData = ws.OpenDatabase(strDatabase, True, False, ";PWD=" & strPassword)