Solved

Changing File Sharing Lock Count in Access 2010

Posted on 2011-03-15
2
1,170 Views
Last Modified: 2013-11-29
I normally use Access 2007 and have run into the File Sharing Lock Count issue and have fixed this using by changing the Registry (HKEY_Local_Machine\SOFTWARE\Microsoft\Office\12.0
Access Connectivity Engine\Engines\Ace\MaxLocksPerFile)

I do not see this sequence when working with Access 2010.
0
Comment
Question by:jaustinr
2 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 63 total points
ID: 35139620
Should be:

HKEY_Local_Machine\SOFTWARE\Microsoft\Office\14.0
Access Connectivity Engine\Engines\Ace\MaxLocksPerFile

JimD.
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 62 total points
ID: 35139659
I suggest you use VBA to change this setting on a 'per session' basis only, and not mess with the Registry for this, which my not be possible on some user machines.  

Put this at the beginning of your code for a temporary override of the Default:
DAO.DBEngine.SetOption dbmaxlocksperfile, 25000  ' or higher if necessary

This works very well  ... in any version of Access.

mx
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question