Error 3035 System Resource Exceeded

[oozyscab via AccessMonster.com]

This seems to be a common problem from looking at all the other postings...

Anyway, I have a very simple query that runs fine from the database window.
However, when this same query is run as part of a transaction in my code, I
get this error.

Is there a registry key that needs to be changed to allow for more resource
allocation or something?

I have plenty of physical memory available and plenty of hard drive space as
well. I am not running this off of the network.

Also, this database is linked to different back-end database files from time
to time and then this query is run. Smaller database files cause no problem.
The problem only seems to occur on one larger file that may use more
resources for the transaction than the smaller files do. I've compacted and
repaired both the larger data file as well as the front-end file and the
problem still persists.

Thanks

 

[oozyscab via AccessMonster.com]

I found the answer...

http://support.microsoft.com/?id=286153

This deals with the registery key MaxLocksPerFile. I changed it from the
default value of 9500 to 50000 and it resolved the issue.