Join with table from another database

[guitarzan]

I have an ASP program, and am accessing data from an Access database; here's some basic code

Dim ConnLog, rsLog, vtmpsql

Set ConnLog = Server.CreateObject("ADODB.Connection")
ConnLog.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & _
	Server.MapPath("/") & "\..\data\log.mdb"

Set rsLog = Server.CreateObject("ADODB.Recordset")

vtmpsql = "SELECT Log.id, Log.logAction, Clients.cliName " & _
	" FROM Log LEFT JOIN Clients ON Log.ClientID = Clients.id"
	
rsLog.Open vtmpsql, ConnLog

...which would work fine, if the "Clients" table were in "log.mdb". Instead, the Clients table is in a different mdb file ("main.mdb"), and this table has a password set on it. How can I complete my join statement?

 

[PHV]

Can't you create a linked Clients table (with password remembered) in the log.mdb DB ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[guitarzan]

Thanks for the reply... yes that will definitely work. I am wondering, is there a way to do this via code, rather than modifying the mdb file?