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