Hi Scott,

A few months ago I posted a similar question here, but did not get it sovled. I have VFP5a (sp3) + SQL Server 6.5. Using remote view with a memo(text) field, I got these observation:

1- It is slow to insert a new record with non-blank memo contents, to the point that I can see the intens hard disk activities for up to five minutes on the server.

2- It is fast to insert a new record if the memo field is empty.
3- It is fast to update an exsiting record with or without memo contents.

Following these three observation, I am using a real dirty way to deal with the problem. On my form, if a new record is added, I issue tableupdate() when I detect that an user enters editbox (memo field), so that I am sure that I insert the record to the server without memo contents first. This is real dirty that some other issues may appear.

Chen