By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,269 Members | 1,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,269 IT Pros & Developers. It's quick & easy.

How do I avoid "File Sharing Lock Count Exceeded (Error 3052)"

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Advice given by Larry Linson to solve what sounds like a similar problem to
yours!
Don't try to do this from datasheet view.

Create a Delete Query in the Query Builder and execute it: Add the Table to
the Query, drag down the * into the grid, then on the menu, click Query and
choose Delete. Execute it with the ! icon on the toolbar. Don't be
impatient, as with a million rows, it will take some time.

--
Reggie

----------
<ja***@cd-worx.com> wrote in message
news:40**************@news.clari.net.au...
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.

Nov 13 '05 #2

P: n/a
ja***@cd-worx.com (ja***@cd-worx.com) wrote in message news:<40**************@news.clari.net.au>...
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.


Take a look at Q173006 on the Microsoft support site. There's a
registry tweak to get round this problem. If, by any chance, your
back-end database is on a Novell server you may also have to change a
couple of things on the server. I don't have the links to hand, but
you'll find them on the Microsoft site - I have to look them up
several times in the past :-)

Mike
Nov 13 '05 #3

P: n/a
Access version please?
Try searching in this ng for
MaxLocksPerFile
i fixed similar problem with
dbengine.setoption dbMaxLocksPerFile,10000 or whatever
note this is a fix for the current session only.
Terry Bell

ja***@cd-worx.com (ja***@cd-worx.com) wrote in message news:<40**************@news.clari.net.au>...
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.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.