How to display MaxLocksperfile?

[prabhafriend]

I know how to set the Maxlockspefile using dao.dbengine.setoptions. But how to read that property?

[stanl]

It would seem that if you know how to set it, you don't need to read it as just remember the number you set it at. I think the default is ~9500. If you use ADO and Jet 4.0 there is

myConnection.Properties("Jet OLEDB:Max Locks Per File").value

that gives a variant.

[prabhafriend]

Stanl. Unfortunately I has to use DAO but I need to read that value on runtime. My boss has instructed me to find someway. Kindly help. How to read that value in a DAO environment?