D
David Mueller
I need to use the DBEngine.SetOption to modify MaxLocksPerFile registry
entry. It just isn't working for me. If I manually change the registry, it
works. But, when I issue the command through VBA, it doesn't work (doesn't
err, either)
My SQL is inside a BeginTrans and CommitTrans block, such as:
Dim wsp As DAO.Workspace
Dim db_wsp As DAO.Database
Set wsp = DBEngine.Workspaces(0)
Set db_wsp = wsp(0)
wsp.BeginTrans
db_wsp.execute "update ...."
wsp.CommitTrans
I've put the code "DBEngine.SetOption dbMaxLocksPerFile, 500000" everywhere
in my code. Literally. It doesn't seem to matter where it goes. I even tried
"Application.DBEngine ..." and sprinkled "DAO.DBEngine.Idle dbRefreshCache"
all about just because I got desperate.
The last thing I tried was to execute my SQL outside the transaction... and
that worked ... but I need the transaction.
Can anyone tell me what I'm missing here?
Thanks
David
entry. It just isn't working for me. If I manually change the registry, it
works. But, when I issue the command through VBA, it doesn't work (doesn't
err, either)
My SQL is inside a BeginTrans and CommitTrans block, such as:
Dim wsp As DAO.Workspace
Dim db_wsp As DAO.Database
Set wsp = DBEngine.Workspaces(0)
Set db_wsp = wsp(0)
wsp.BeginTrans
db_wsp.execute "update ...."
wsp.CommitTrans
I've put the code "DBEngine.SetOption dbMaxLocksPerFile, 500000" everywhere
in my code. Literally. It doesn't seem to matter where it goes. I even tried
"Application.DBEngine ..." and sprinkled "DAO.DBEngine.Idle dbRefreshCache"
all about just because I got desperate.
The last thing I tried was to execute my SQL outside the transaction... and
that worked ... but I need the transaction.
Can anyone tell me what I'm missing here?
Thanks
David