Cathi;

Only four more Mondays in this week until the weekend! :)

Tom

>Thanks Craig for pointing this out. I read right over that. It must be Monday!
>
>>Cathi,
>>
>>As he is going to SQL Server, the VFP OLE DB provider doesn't come into play here.
>>
>>
>>>Are you using VFP7 or a version earlier? If you are using VFP7 then I would recommend using the OLEDB provider instead of ODBC.
>>>
>>>You can set your connection on the fly instead of setting up your connections ahead of time on each machine. You would use the SQLSTRINGCONNECT function to set it.
>>>
>>>>I will be designing an application which will be used by numerous
>>>>individuals, which will need to access various SQL Server tables for
>>>>reference lists. I have done very little work with SQL Server.
>>>>
>>>>Is it necessary to set up ODBC-type connections individually at each PC
>>>>which will use this application (during application setup), or can Visual FoxPro "on-the-fly" set up temporary connections to the SQL Server tables as needed?
>>>>
>>>>Thanks,
>>>>Randy W.