Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • Last Modified:

File Sharing Lockout mystery - Error 3502

Greetings To All.
===========

I have several genalogical databases with thousands of records.

Today, for the first time, I encountered the error message:

"File sharing lockout exceeded.
Increase MaxLocksPerFile registry entry"
Error 3052

I am out of my depth since I already have other tables with a similar number of records.

Your words of wisdom are eagerly awaited.

robinski
0
robinski
Asked:
robinski
  • 3
  • 2
  • 2
1 Solution
 
repsteinCommented:
I am not sure why you are running into a MaxLocks problem, but here is how to increase the number of locks allowed:

Run regedit

There may be several MaxLocksPerTable entries. I'd suggest changing them all, although you probably only need to fix the latest version.

Navigate to:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet

Then on the main toolbar select:
Edit | Find and enter
MaxLocksPerFile

The MaxLockPerFile key will be displayed. Double click on the Name to open the change value dialog box.

The default is 9500 (251c in hex)

Increase this value (eg, to 10000 decimal or 2710 hex)

Hit the F3 key
Increase the next occurence of the key

Repeat the F3, replace until no more are found

(you can click Cancel button to stop the search)

Then close the regedit program.

A few warnings about the registry, if you haven't been here before.

Any changes you make are immediate. Be very careful in here as to what you change, as you can really screw up your machine. The area you are in (Software) is relatively safe, however.

Richard


0
 
spruce22Commented:
hi robinski,

From Access help, this error occurs on recordset objects, and may be due to the amount of memory available on the computer, the size of rows in the recordset, or network operating system restrictions. Were you running other programs that you usually don't when this occured? Have there been any recent network changes?  If not, could you explain or post the code where this error is occuring, and maybe give a descripiton of the table structure?  Other experts may be able to help you with your question immediately, but I would need a little more information to be of assistance.

You could simply increase the MaxLocksPerFile registry value, but I'd look into why the error is occuring before jumping into modifying Jet registry settings.
 
spruce22
0
 
robinskiAuthor Commented:
Hi Spruce22

There is no network involved.

The table structure is, broadly,

Seven text fields.

No obvious complications.

repstein
======

I will follow your advice and report later.

Thanks to both.

robinski
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
repsteinCommented:
I poked around in Microsoft knowledgebase and came up with the following (in addition to what spruce22 suggested as possible causes).

In Access 97 you can get error 3052 during synchronization of a replica if the files are huge and you have added many new records. The fix is to edit the registry as I described.

http://support.microsoft.com/support/kb/articles/Q173/0/06.ASP

For Access 2000 the problem and the fix is the same. See
http://support.microsoft.com/support/kb/articles/Q198/6/33.asp

************************************

If you want to set the MaxLocksPerFile temporarily within your database, you can use the SetOption method. (search in Access for SetOption in help for more details). Briefly:

DIM nTempLocksPerFile as variant
nTempLocksPerFile = 10000
SetOption dbMaxLocksPerFile, nTempMaxLocksPerFile      

Richard

0
 
repsteinCommented:
In my example, that should have read:

SetOption dbMaxLocksPerFile, nTempLocksPerFile

which I'm sure you realized.

Richard
0
 
robinskiAuthor Commented:
spruce22
======

Rebooting released memory and the job is done.  

I should have thought of that.

robinski
0
 
spruce22Commented:
robinski:
Glad you were able to fix your problem, even though it only required a reboot. That's fixed many "mysteries" for me as well, but the solution doesn't always come to mind at first.  At least you know your datbase isn't sick, or performing such complex operations that it exceeds Jet's default MaxLocksPerFile settings.

spruce22
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now