Search results for query: *

PHV, You are correct in that an update query is the normal way to update a recordset... However, in this case there are a number if then/else statements that are setting some values and doing some calculations so it would end up being several update querries and then I would. I didn't write...

Jo, I just saw your second post... Sorry, I can't send you the data. It has SSN's for about 3500 employees in it! I checked the table and there are some numeric fields, but they are all "long". There are a number of date fields also. The remainder of the fields are mostly text with a...

Jo, Thank you for the information, but I don't think it directly relates to the problem I described. I am using the .update command on data rows, not project items. I am using a transaction and have a commit after every 10000 updates to try and keep the level of system resources (lock...

Hi, Has anyone resovled this issue? I have encountered it also and have been very frustrated. My table has about 500,000 rows that are being updated, one at a time using the .edit .update methods. I tried using transactions to limit the number of changed records before committing the data...