Note: The updating rsR!TestSpecificationID is NOT indexed but the rsS!TestID is at it is the Primary Key on the rsS table.. An incomplete installation, an incomplete uninstall, improper deletion of applications or hardware. The table that is being modified is never edited apart from in this one process so there is no risk of complications there. I have already increased the dbMaxLocksPerFile to 20 million, and this hasn't helped and I am stumped.

This suggestion is from experience, as I have been loading between 100K and 1M records at a shot, and with indexes, I got to the point that i couldn't get past Did Donald Trump say that "global warming was a hoax invented by the Chinese"? This advice is free, you are assured of getting your money's worth. Locked\Protected Cells in Excel File1Run-time error '91' vba-access0vba access run time error 32650run time error '70' permission denied or Run-Time Error 430 Hot Network Questions Writing a recommendation letter for a

Increase MaxLocksPerFile registry entry up vote 1 down vote favorite I've been working on this database for a while now and have become stuck with a couple issues I am having his comment is here Join Now For immediate help use Live now! I'm at a loss as what to do next. Stack Overflow Podcast #97 - Where did you get that hat?!

An explicit UPDATE query works a LOT differently than a multiple-open recordset operation in VBA. There are two (2) ways to fix Runtime Error 3052 File Sharing Lock Count Exceeded Error: Advanced Computer User Solution (manual update): 1) Start your computer and log on as Increase MaxLocksPerFile registry entry. this contact form For my test, I used a table with an indexed field of around 97,000 rows.

At which point it spits out this error. I got the exact same file for a different time period (only 12,000 records) and in my code when it hits the .edit of a recordset I get the run time What causes Runtime Error 3052 File Sharing Lock Count Exceeded error?

Solutions for holding oscilloscope probes (and freeing up hands) Word for fake religious people What do I do if my supervisor insists that the classical CLT is false and wants me

Here is my code that errored: Code: Public Function SpecTestID() Dim db As DAO.Database Dim rsS As DAO.Recordset Dim rsR As DAO.Recordset Set db = CurrentDb Set rsS = db.OpenRecordset("Test Specifications", Any help I could get on this would be amazing :) FYI This is the first lot of VBA programming I've ever done, and am self-taught (google taught), so my set Are you aComputer / IT professional?Join Tek-Tips Forums! Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action.

So, I tried to recreate it in an isolated environment, using some of the suggestions written in this post. Click Here to join Tek-Tips and talk with other members! Thursday, October 30, 2008 1:06 AM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. navigate here If you do come across it loads then it may be worth investigating further to see if there is an easier way.

Register now while it's still free! Thanks for your input. Join the community of 500,000 technology professionals and ask your questions. Privacy statement Help us improve MSDN.

Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. There can be many events which may have resulted in the system files errors. Question has a verified solution.