473,327 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Error 3052 File sharing lock exceeded

Hi All,

Recently encountered problems with "Error 3052 File sharing lock exceeded". I have done some research and found the aswer here on the forum. However, I have the following questions:
- The number of records in my file (text file) are only small - 3500 and this error is happening. Thought it was suppose to occur only in big files?
- could it be in the code? it is stated "dbopentable" does that mean that the locking is done on the table e.g over 200,000 records. Would dbopendynamic be better?

Please provide any tips, suggestions etc.

thanks!
May 8 '06 #1
3 4809
cweiss
36
I don't think the type of recordset matters in this case.

I've never had this problem, but from what I've read, you could theoretically get this error with any number of records, it all depends on the value you've assigned to your MaxRecordLocks (or the value your administrator has set it to if you're on a Novell Netware server).

You've probably already seen how to adjust the MaxRecordLocks. Microsoft's technet article on the subject is here:

http://support.microsoft.com/kb/q198633/

Your administrator will have to adjust it, though, if you are on a Novell Netware server.

If this doesn't solve your problem I'm not sure what you need to do, never had this problem myself so I'm only rehashing what I've read elsewhere on the subject.
May 10 '06 #2
Hi cweiss,

thanks for your response. Appreciate it.

you are right, I have tried adjusting the MaxRecordLock in the registry on the server and my computer. However, regardless of what number I put, eg 500,000 , it does not make a difference. Instead, I managed to load the file once most users have stopped using the server.

that was why I thought it might be the recordset.

Any more tips would be helpful...anyone????
May 11 '06 #3
cweiss
36
Hmm, do you think it could be the number of users connecting to the DB simulateously? I don't use access as a backend (it sounds like you are though), so I wonder if that's why I've never had this problem.

I found a post that might help on google groups. One good point he made, I thought, was that if you use bound form, then every time it's opened, a connection to the underlying recordset will be opened.

Yes, we have a number of databases which are used concurrently by 50-100 users, with few problems. In certain "high volume" databases you may run into "record locking" (which is really page locking of 16 KB, I believe.). However, you can adjust the Record Locking "levels" in Tools ---> Options ---> Advanced, clicking on the "Edited Record" button, so that there is minimal locking.

I believe that there is a limit to the number of people that can have an
Access file open at the same time (about 256, I believe). But there are ways around this.

First would be to use SQL Server as a back-end. Second would to use UNBOUND forms for everything in the front-end (using SQL Server or Access as a back-end) and have absolutely NO linking of the front-end to the back-end. Instead, all data is called up and/or written to the back-end via SQL commands. In short, the user is connected to the back-end file only for the miniscule fraction of a second that the record is pulled into the form or being updated back into the table. (However, unless you are talking a really high production environment, e.g., have 1000+ users continuously entering data into the same back-end all day long non-stop, this probably isn't necessary.

---Phil S.
This may not be applicable to you though.

I am kinda curious as to what's causing your problem. If you find a solution before somebody here does, I'd be interested to hear what you did to fix it.
May 11 '06 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: rdavis7408 | last post by:
I have a database that has a form that opens a report using date parameters. I have been using it for six months and last week I began to get the following Error Message: "File sharing lock...
8
by: Bri | last post by:
Greetings, After making various edits and deletes on aproximately 40,000 records in one table (on the Design Master) syncronization fails with Error 3052 - File Sharing Lock Count Exceeded....
3
by: jamie | last post by:
Hi, I'm trying to delete a whole bunch of records and keep getting the message "File Sharing Lock Count Exceeded (Error 3052)". What is this error and how do I overcome it? Thanks guys.
9
by: JTrigger | last post by:
When I compile my project using the IDE on a development machine it works just fine. When I compile it on the server using csc.exe, I get the following error when I try to bring it up in the web...
13
by: George | last post by:
Hi, I am re-writing part of my application using C#. This application starts another process which execute a "legacy" program. This legacy program writes to a log file and before it ends, it...
17
by: Peter Duniho | last post by:
I searched using Google, on the web and in the newsgroups, and found nothing on this topic. Hopefully that means I just don't understand what I'm supposed to be doing here. :) The problem: ...
3
by: fperri | last post by:
I have a DB in Access 2002 that when it is ran on a few users computers in the company, they get the error that the file sharing lock count has been exceeded and to increase the max locks per file in...
1
by: scriptgirl123 | last post by:
Hello, I am running one of my own scripts with some loops in between. It does work from start to finish, but I get this error message popping up in between: Run time error 3052 File...
11
by: limperger | last post by:
Hello everybody! I have just found out that the sharing properties of a single database (mdb file on a network), accessed by 3 users, change depending on the user accessing the database. That is,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.