none
Max number of open connections with MS Access 2007 database? RRS feed

Answers

  • Hi Parag,

    The MaxLocksPerFile setting determines the maximum number of locks Microsoft Jet places against a file. The default MaxLocksPerFile value is 9,500. However, do not change this value if you are working on a Novell NetWare server, because the maximum server record locks per connection is 10,000.

    How to modify it: http://support.microsoft.com/kb/815281/en-us

     

    Best Regards

    Yichun Feng


    • Marked as answer by Parag Meshram Friday, August 28, 2009 11:55 AM
    Wednesday, August 26, 2009 7:03 AM