Hello,
My current application opens and runs a procedure in a separate Access
database. It looks like this.
Public Sub ProcessAll()
Dim appAccess As New Access.Application
appAccess.OpenCurrentDatabase ("G:\RebateReport.mdb")
appAccess.Run "ProcessAll"
appAccess.CloseCurrentDatabase
End Sub
The problem is "RebateReport.mdb" must be closed or it will not
process. I need code that would close it if it were open and then
re-open and run it.
I need to add something like:
appAccess.Path="G:\RebateReport.mdb"
If appAccess.IsOpen Then
appAccess.FileClose
EndIf
Of course this is improper syntax. How would I do this?