resource exceeded

[idxyz]

Hi,

to solve the reource exceeded error in my 2016 access database, could I include this line in the main Form's Load handler:
DBEngine.SetOption dbMaxLocksPerFile, 50000

 

[arnelgp]

you can.
you can even have it once in a function:

public function fnMaxLock()
DBEngine.SetOption dbMaxLocksPerFile, 500000
end function


then RunCode it on AutoExec macro.