P
Paul
I am trying to run an update query in VBA and I get the 3734 error. This
does not happen every time the program is run but it does happen often. The
error says that user Admin has placed the database is the state, which tells
me that no one was using the database at the time because this program runs
at 4 AM. The code I am using follows:
Dim objAcc As Object
Set objAcc = GetObject("\\SCSEDDC10\common$\Helpdesk &
Security\ADP\~Operations\Databases\Staff2.mdb")
objAcc.CurrentDb.Execute "BDay - Creation"
Should I use some other method to run the query?
does not happen every time the program is run but it does happen often. The
error says that user Admin has placed the database is the state, which tells
me that no one was using the database at the time because this program runs
at 4 AM. The code I am using follows:
Dim objAcc As Object
Set objAcc = GetObject("\\SCSEDDC10\common$\Helpdesk &
Security\ADP\~Operations\Databases\Staff2.mdb")
objAcc.CurrentDb.Execute "BDay - Creation"
Should I use some other method to run the query?