How to display MaxLocksperfile?

[prabha_friend]

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

 

[the_net_2.0]

try:

GetOption("Maxlockspefile")

or whatever the argument is. if you know how to set it, then you should know the arg name.

throw it into a variable and print the var.

 

[vbaInet]

I believe that's a registry setting and there's no GetOption method of the db Engine object.

You need to read the registry to get the value, but you must use the full path. I think the default max number is about 9k.

 

[jdraw]

See this link for info
http://support.microsoft.com/default.aspx?scid=kb;en-us;286153
Sample includes
.... ' Set MaxLocksPerFile.
DBEngine.SetOption dbMaxLocksPerFile, 200000
....

 

[the_net_2.0]

I believe that's a registry setting and there's no GetOption method of the db Engine object.

thanks for saving the day. (if that's what you did)

getoption is an application method.