>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.