>Is this clause set to no as default or do I need to add this in all my connection strings? I want to make sure that multi users can read/write to the remote tables with out any problems.
The default for SET EXCLUSIVE in VFP ODBC driver is OFF.
>How can I write(update) data to a remote table with only the record locked and not the table?
I'm not sure what you mean.
--sb--