All this is assuming as well that you aren't commiting until all are deleted. I would recommend AutoCommit => 0 as well. It seems like it would solve your problem. But if the transaction in question is one you would want to roll back as a whole, then maybe this will give you some insight as to where to begin your search to fix this limit. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Jet 3.5 contains a REG_DWORD called MaxLocksPerFile. When using M$-ACCESS you can hack that number up to avoid that error. I have mine set at 4294967295 (the max of a REG_DWORD) This is the kind of thing you might want to look for assuming you're on window$. I'm not saying that this specific key is your problem, but rather to consider that it could simply be some arbitrary value in the registry such as this one that is soft limiting you.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.