While working on an MS Access problem someone recommended I increase the MaxLocksPerFile value from the 9500 default to 200,000 shown in the example from MS Support. It didn't solve my problem but my users other queries ran faster. This is generally considered a good thing.
So here is my question... what is the upper limit for the MaxLocksPerFile value? Reasoning that if 200K is good 500K must be better right?
This job would be sooo much easier if wasn't for all the users and their problems!