Are you using an ODBC DSN to point to the VFP database/tables? If so, are you sure that is not set to try and get Exclusive Use....

>Let me give you the background first:
>I have written a COM object in VB that creates a socket to a C++ backend application. The FoxPro form sends requests to the COM object which then forwards to the C++ backend. Then the C++ backend returns the data to the COM. The COM then parses it and saves it to my VFP6 table. Still with me? The COM uses ADO to open a connection and a recordset to my VFP table and then sends the recordset as an updateBatch.
>
>The problem:
>VFP and the COM object give OLE DB for ODBC errors or cannot access database errors. Evidently if I want to use the COM object to save to VFP then I must 'close tables' before I use it. Why won't they let me share the tables? This seems to be the problem. I've used set exclusive off, but to no avail. I can't keep closing everything and then reopening everything with every command. Any Help?
>
>-robert