Results 1 to 10 of 10
  1. #1
    johnmerlino is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    97

    File sharing lock count exceeded. Increase MaxLocksPerFile registry entry.

    Hey all,

    I try to add id field to table and get this:

    "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry."

    Table only has a little over a million records.

    So I try to troubleshoot with MS recommendation (note that I'm actually using MS-Access 2010):

    In Microsoft Office Access 2007 that is running on a 32-bit Windows operating system, use Registry Editor to locate the following registry key:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\ Access Connectivity Engine\Engines\ACE
    # n the right pane of Registry Editor, double click MaxLocksPerFile.
    # On the Edit DWORD Value dialog box, click Decimal.
    # Modify the value of the Value data box as required, and then click OK.




    I change value to 5000000 and I still get this in Access:

    "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry."

    I try to change value to 9000000 and I get this from Windows XP:

    "The decimal value entered is greater than the maximum value of a DWORD. Registry Editor will truncate the value entered."

    So I'm not sure what to do. I'm just trying to add an id field to a table.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Are you running some sort of query? Have you done a Compact and Repair yet? Have you tried *importing* your db into a fresh new db and see if the problem follows?

  3. #3
    johnmerlino is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    97
    Thanks for response.

    * I wasn't running query. I was just trying to add a new field id primary key auto increment.

    * I tried compact and repair and it still gave error.

    * I don't know what you mean by export database. I googled and there was no example of how to export a database. I saw examples of how to export tables to excel, but not full databases.

    Thanks for response

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Here's an example with pictures: http://www.btabdevelopment.com/ts/impnew

  5. #5
    johnmerlino is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    97
    Thanks I always like pictures, albeit those are from 2007 not 2010 version. It worked nevertheless.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Did the problem follow?

  7. #7
    johnmerlino is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    97
    It seems problem is solved.

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Great news. Go ahead and use the Thread tool and mark this thread as Solved.

  9. #9
    ggratecc is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    1
    I also had this same problem with win7 and access2010.
    I created a new database, imported objects and this solved the problem!
    thanks, Greg


    Quote Originally Posted by johnmerlino View Post
    It seems problem is solved.

  10. #10
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Thanks for the additional info Greg!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Sharing the database file
    By mme in forum Access
    Replies: 4
    Last Post: 09-10-2010, 08:45 PM
  2. File Sharing Lock Exceeded
    By creditman in forum Access
    Replies: 1
    Last Post: 07-15-2010, 09:49 AM
  3. Sharing workgroup file
    By allykid in forum Access
    Replies: 11
    Last Post: 07-08-2010, 11:17 AM
  4. Replies: 2
    Last Post: 06-17-2009, 09:50 PM
  5. File sharing lock count exceeded
    By bullwinkle55423 in forum Access
    Replies: 0
    Last Post: 03-22-2007, 11:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums