How can I "slow down" an append or update query?

[securitywyrm]

The title is correct, I need a query to run SLOWER rather than faster. Specifically I'd like it to run one line at a time.
The reason for this is that I'm updating information in a Sharepoint list, the server of which I am convinced is on an ISDN line for thousands of users. When I try to run the append query directly, there's a lot hanging and then hundreds of copies of the same record wind up getting added. Thus I was wondering if there's a way to 'slow down' a query, have it run one line at a time, to perhaps avoid the 'stutter' causing duplicate records.

[ranman256]

make a loop to update 1 set at a time....like :

dim vCity
for each vCity in countrys
   sSql = "update table1.[field]=table2.field2 from table1,table2 where [city]='" & vCity & "'"
   docmd.runsql sSql 
next

[NTC]

fundamentally you have a Wide Area Network in the middle

put both front & back on the same server - and remote into your front.

[securitywyrm]

Thank you, I think that will work! I'll give it a try as soon as I can.