Hi,
I inherited a Access database, which runs data downloaded from Wufoo forms.
I then run a .vbs script, which saves the excel into a path and then opens the database to import excel data and then run queries.
The database part of the code in the .vbs script is as below.
[/CODE]
I checked the database and there is only a macro for pause and nothing else.
How to check which queries are being executed.
TIA
I inherited a Access database, which runs data downloaded from Wufoo forms.
I then run a .vbs script, which saves the excel into a path and then opens the database to import excel data and then run queries.
The database part of the code in the .vbs script is as below.
Code:
[CODE]...................
Dim db ''As DAO.Database
Dim ac ''As Access Application
Set ac = CreateObject("Access.Application")
ac.OpenCurrentDatabase("C:\access\perf_data_fe.accdb")
set shl = createobject("wscript.shell")
shl.sendkeys "^{F4}"
set db = ac.CurrentDB
ac.docmd.openform "frmDone"
'ac.docmd.closeform "frmDone"
'appAccess.DoCmd.Close 3, cstrReport ' acReport = 3
'appAccess.Quit
'Set appAccess = Nothing
.........
I checked the database and there is only a macro for pause and nothing else.
How to check which queries are being executed.
TIA