How to Run different database query in ms access Form

Question

I have following code to run saved query and export data to excel report. How should I change the code if this query is in a different database?

DoCmd.Requery Q_Check_Mismatches
DoCmd.RunSavedImportExport "Export-Q_Check_Mismatches"

I know we can link all relevant tables to current database and then run the query locally. But I need this because of DB size issue.

Appreciate your response

Cheers

Shabar

Have you considered "Compacting" the database to reduce its size? That may solve the issue — Katana24
Yes Katana24, But still I am after this setup as I planned to access different DB when running query — shabar
have a look at this: answers.microsoft.com/en-us/office/forum/… — Katana24

shabar shabar · Accepted Answer · 2013-04-10T03:12:31

Following code worked for me

Function QueryRun(strDBPath As String, strImportExport As String) 

Dim objAccess As Access.Application 

Set objAccess = CreateObject("Access.Application") 
objAccess.OpenCurrentDatabase 

strDBPath objAccess.DoCmd.RunSavedImportExport strImportExport 
objAccess.CloseCurrentDatabase 
objAccess.Quit 
Set objAccess = Nothing 
End Function

Cheers

Shabar

How to Run different database query in ms access Form

1 Answers