Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Upper End For MaxLocksPerFile Value


  • Please log in to reply
2 replies to this topic

#1 TheGreyGuy

TheGreyGuy

  • Members
  • 28 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Tacoma, WA
  • Local time:11:33 PM

Posted 20 July 2010 - 10:59 AM

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? :thumbsup:
This job would be sooo much easier if wasn't for all the users and their problems!

BC AdBot (Login to Remove)

 


#2 thrillhouse

thrillhouse

  • Members
  • 1,040 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Va
  • Local time:02:33 AM

Posted 20 July 2010 - 11:14 AM

What's the problem?

#3 TheGreyGuy

TheGreyGuy
  • Topic Starter

  • Members
  • 28 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Tacoma, WA
  • Local time:11:33 PM

Posted 20 July 2010 - 11:21 AM

The other thread is "Not enough space on temporary disk."
This job would be sooo much easier if wasn't for all the users and their problems!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users