Run-time error '3035'

[hotstream]

Hi!

Short Introduction.
Table 'People' - the table contains info about people. two of the fields are 'PersonalEmail' and 'ReferrerEmail'. It means, each person has it's referrer. Referrer is one of the existing persons in the table.
Queries.
* I have some queries that calculate statistics for persons - No problem.
* I have queries that find 1st, 2nd, 3rd, 4th generation for defined person from table 'People' (it means i chose in form any person and want to see, what his 1st generation - where he is the referrer, 2nd generation - where his 1st generation is referrer and so on...) and combine this data with the person statistics, that calculated in the queries i've described above. - No problem.
* I'm trying to calculate total statistics for generations described above - query. I succeed to do it only for first 2 generations and get the error: Run-time error '3035' and the message is: System Resource Was Exceeded (it's my translation ), when i'm trying to run the 3 generation query.

Could you explain me what happened?

 

[tigger_na]

This could be the record lock register. In the windows registry, search for all occurences of "MaxLocksPerFile". This may be located under My computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x, and Jet 3.5. I'm running Access 2002 and Windows XP.

The default value is 9500. I increased mine to 100 000, and the 3035 error disappeared.

What I cannot say is how safe this modification to the Windows registry is.

 

[pbarnes]

Registry Edit Safety

Tigger -- have you had any feedback as to whether editing the registry is somewhat safe? I have the same problem with the MaxCounts and I'm hesitant about messing with the registry. If I can simply change it, perform the action I want, then change it back then I would do it but I want to know if I can do that prior to actually doing it.

Here's a link to my other post if you need more background:
http://www.access-programmers.co.uk/forums/showthread.php?t=134560

 

[Jon K]

You can temporarily change the MaxLocksPerFile value.

See Method 2 in this link:
http://support.microsoft.com/kb/815281/en-us
.

 

[tigger_na]

I've had no adverse effect

after doing this. Its a single line that gets changed, and its just as easy to unchange.

I did alot of reading up on this matter, but cannot recall what exactly causes this problem. You've only seen the effect, which may indicate an underlying problem with your database.