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


  • 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:


    Best Regards

    Yichun Feng

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