Recent content by elektr

Thanks a lot!

Hi! Could anyone help me with this: I have a table with 50 fields (all text) and I would like to run an update query on all of these, here's an example: UPDATE Sheet1 SET Sheet1.[28] = 0 WHERE (((Sheet1.[28])="")); The fields are numbered 1-50 I appreciate any help Thanks

............

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.

1074 KB, the limit on this forum for .zip is 785.9 KB

it is too large for uploading here, maybe I can use some uploading site? Which one do you prefer?

By the way, the file is 1074 KB, where can I upload it for you?

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.

How can I check this? The code runs for about 2 hours until it gives this error.

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...

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...

Do you know if there are any articles that describe this kind of problem and the solution?

Ok, never mind, I'll figure it out. Cheers

khawar, you are a genius, this is exactly what I need! by the way, can you please modify the query so that there is no "AssetValue" field in table Assets and no "Balance" field in table Customers? The result would be just the combinations of customers and assets without the numeric calculation...

yeah, sorry, had it wrong, uploaded again.