Calculations with many-to-many relationship

I think you can do it yourself now
 
I posted the solution already.
Here it is implemented.
 

Attachments

Do you know if there are any articles that describe this kind of problem and the solution?
 
it's solved, I just want to educate myself.
By the way, I ran the query with about 3000 assets and 3000 customers and it worked perfectly giving the result in about 5 minutes. Now I am testing it with 30000 assets and about 25000 customers (all have many-to-many relationships). Access gave me "File sharing lock count exceeded" error message, so I increased
maxlocksperfile to 1000000 (see http://support.microsoft.com/kb/815281). Now it is running again, I'll let you know when it finishes.

 
It is still giving me "file sharing lock count exceeded. increase maxlocksperfile registry entry" I cannot change my registry because of policy restrictions. I typed "DAO.DBEngine.SetOption dbmaxlocksperfile,1000000" into immediate window and pressed return. After running the code again, still same error.
 
At which routine it gives the error I think its Update Sequences
 
How can I check this? The code runs for about 2 hours until it gives this error.
 
can you upload database zipped (if possible)
 
can you upload database zipped (if possible)

I can upload data if you state that you will not charge any money now or in the future for this help. Sorry for that, corporate regulations.
 
By the way, the file is 1074 KB, where can I upload it for you?
 
We are here to solve your problems and giving you advice no one can charge you for giving advice on this forum
 
it is too large for uploading here, maybe I can use some uploading site? Which one do you prefer?
 
1074 KB, the limit on this forum for .zip is 785.9 KB
 
you can check your self where the code breaks by stepping into the code
and by the way how many assets and customers you have in database
 
it does not break when I run through the cycle. The code runs for about 2 hours and then gives me this error. I have 16 000 assets and 16 500 customers and there are 30 000 relationships between them. The algorithm is correct but I guess there is some Access memory handling problem involved.
 
I cant guess I have to see whats happenings
 

Users who are viewing this thread

Back
Top Bottom