Problem with DBengine.SetOption dbMaxLocksPerFile

  • Thread starter Thread starter David Mueller
  • Start date Start date
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
 
Back
Top