open external database

[xsnrg]

I am looking for the code that would open another access database in the background. Any leads?

 

[HBWAL]

You can use the OpenConnection method to open an ADO connection to an existing Microsoft Access project (.adp) or Access database (.mdb) as the current Access project or database in the Microsoft Access window.

expression.OpenConnection(BaseConnectionString, UserID, Password)

Try this

 

[xsnrg]

I tried that with this modification...
expression.OpenConnection ("d:\wwireless\sql-baseline.mdb")

There is no username or password so I left it like this but it didn't work. Any suggestions or corrections?

 

[PHV]

but it didn't work
Any error message ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[cmmrfrds]

I have used this code to open an Access Project.

Option Explicit
Public pubAppAccess As Access.Application, pubOldAccess As Access.Application
Public pubFilePath As String

' Open Access project.
pubFilePath = "C:\maindir\test\projects\remotepubs.adp"
Set pubAppAccess = New Access.Application
pubAppAccess.OpenAccessProject pubFilePath

pubAppAccess.Application.RefreshDatabaseWindow
pubAppAccess.Application.Visible = True