Results 1 to 2 of 2
  1. #1
    creditman is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Jul 2010

    File Sharing Lock Exceeded

    I have recently installed access 2010, and have been transferring data from Access 2003 version.

    However files in one of my databases is in excess of 16,000 files.

    I can transfer about 6,000 at a time with no difficulty from other forms .. but as soon as i go for large transfers, I get an error message saying ..

    "File Sharing lock Exceeded" during large transaction processing ..

    Increase MaxLocksPerFile Registry Entry.

    I have already gone into Regedit .. but it made no difference.

    Does anyone know how I can overcome this problem ?

  2. #2
    DaveT is offline Access Developer
    Windows 7 Access 2010 (version 14.0)
    Join Date
    May 2010

    Method 2, for example:

    DAO.DBEngine.SetOption dbmaxlocksperfile,15000

    Also, I've found that using queries, such as append, will run whereas VBA/DAO code throws the locks exceeded error.

    The SetOption technique has worked for me in VBA/DAO.

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

Similar Threads

  1. Sharing workgroup file
    By allykid in forum Access
    Replies: 11
    Last Post: 07-08-2010, 11:17 AM
  2. Sharing a Form
    By BCullinan in forum Forms
    Replies: 1
    Last Post: 06-03-2010, 03:27 PM
  3. Replies: 0
    Last Post: 08-20-2008, 10:14 PM
  4. File sharing lock count exceeded
    By bullwinkle55423 in forum Access
    Replies: 0
    Last Post: 03-22-2007, 11:58 AM
  5. Link table using MAC PC file sharing problem
    By TaiYipStreet in forum Access
    Replies: 0
    Last Post: 07-19-2006, 08:02 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