Run a query from another database 1

[SERT1]

Does anyone know how to run a query in another database? I.e. vba code in database1 runs query in database2.

 

[LonnieJohnson]

Is it an update query or a select query? If select, are you wanting to use it in a report/form or just view it?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[GGleason]

SERT1,

See if you can make the following work for you:
[tt]
SELECT q0.*
FROM \\MYSERVER\Share\database1.mdb.Query1 AS q0;
[/tt]
hth,
GGleason

 

[SERT1]

So far I've had no success in getting these methods to work. Any more suggestions? I'd greatly appreciate it.

 

[SERT1]

Lonnie, the answer you gave me worked great!!! Thanks so much. I'll post it below for others to benefit from. The only thing people should keep in mind is that if you are using a front-end, back-end application, this code must be written to the back-end. Here's the code:

Public Function RunOutSideQry()
Dim app As Access.Application

Set app = CreateObject("Access.Application&quot

app.OpenCurrentDatabase ("c:\test.mdb&quot

'check to see if the table exist
Dim tbl As TableDef

For Each tbl In app.CurrentDb.TableDefs
If tbl.Name = "MyTable" Then
app.DoCmd.DeleteObject acTable, tbl.Name
Exit For
End If
Next tbl

app.CurrentDb.Execute ("MyQuery&quot
End Function

Again, thanks sooo much.