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

  • Question

  • What is the max number of open connections for MS Access 2007 database?
    Monday, August 24, 2009 6:45 AM


  • 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