[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

MaxLocksPerFile

Posted on 2013-01-08
6
Medium Priority
?
1,619 Views
Last Modified: 2013-01-08
What is the maximum value I can set for MaxLocksPerFile?
(I'm using Access 2007).
0
Comment
Question by:NNOAM1
  • 3
  • 2
6 Comments
 
LVL 40

Expert Comment

by:als315
ID: 38754389
It is Jet's locks quantity. If you have no lock errs, don't touch it.
Look at this article:
http://support.microsoft.com/kb/815281/en-us
I'm not sure there is some maximum, in this article it is 200000. It is limited to server's abilities.
http://support.microsoft.com/default.aspx?scid=kb;en-us;286153
0
 
LVL 59
ID: 38754446
There is no max that I'm aware of although it's stored in the registry (DWord I believe), so the max value would be what 32 bits can store.

The idea of MaxLocks was to prevent run away operations from consuming all server resources under Novell.  But of course the same applies to any OS.  That many open fie handles would be a problem for any OS.

If your having a problem with locking, there are other things you can do, such as setting the UseTransaction property on queries to No.

Jim.
0
 

Author Comment

by:NNOAM1
ID: 38754568
So, what is the max value for a DWORD that 32 bits can store?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 59

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 38754807
<<So, what is the max value for a DWORD that 32 bits can store? >>

 4,294,967,295

Jim.
0
 
LVL 59
ID: 38754824
I should add that I've never had to go higher then a hundred thousand over the past twenty years.

 If your taking out that many locks on a MDB, you've got other problems.

 Default BTW is 9,150.

Jim.
0
 

Author Closing Comment

by:NNOAM1
ID: 38754826
Thank You!
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question