I have a Visual FoxPro Application that contains 4 DBCs and some Free Tables. As an add on tool I provide an Access Application that gives a static(but synchronized) version of the data. After many days of hair-pulling, I resorted to ADO Programming to delete the local Access Tables, Create piece-by-piece the tables then fill record by record the data.

I would like to know if there is a fix for the following problem:

I know the DoCmd.TransferDatabase will save me overhead and code updating time later as revision to table structures occur. My problem, however, is that I can only connect to one DBC. I am successfully able to connect to any one DBC and import all of its tables programatically. When I try to connect to the next DBC, however, the application halts with the error :

Run-Time Error '3184'
Could not execute query; could not find linked table.
[Microsoft][ODBC Visual FoxPro Driver]Ca (#562)

I know the code is accurate because I can run each DBC procedure individually, but upon moving to the nect DBC it fails.

Any response would be helpful, thank you.