I have a remote view to an SQL table of about 100,000 records.

if I open the table, then say Go Bottom (to give it time to open) and then say:

Replace all XXX with .f.
Tableupdate()

It will update a few records then give me UPDATE CONFLICT

So I put a a Do While loop and Replace XXX with .f. then a Wait Window Timeout .1 and Tableupdate() and it goes down the file a lot farther, but that is slow and it too eventually stops.

If I put Wait Window Timeout 5 it goes much farther, but eventually says my ODBC connection is BUSY.

Obviously I have some seting wrong because on a 100,000 record file I can not wait several seconds for each Tableupdate().

Should this work???

Replace all XXX with .f.
Tableupdate()


Thanks
Joel
Houston, TX