Error Link Object is not supported during an insert into from command

[former_member594021]

Developing a program using ADS v11 on Visual Foxpro free tables with adsDataAdapter, I want to copy records from a current table into a history table: INSERT INTO c:\data\hinv.dbf FROM c:\data\cinv.dbf WHERE [balance] = 0.00. I get the error: The requested object was not found. c:\data\hinv Link object is not supported on free connection. Table name: dbf. The connection string includes Data Source: c:\data\; TableType=VFP; LockMode=COMPATIBLE; ServerType=LOCAL. The connection works perfectly for SELECT, INSERT, DELETE and UPDATE commands not using a subquery, for example INSERT INTO c:\data\hinv.dbf ([field1], [field2]) VALUES (value1, value2) will work with no problem.

[former_member594021]

Let me make a correction - the command string is actually INSERT INTO ... SELECT * FROM ... - I neglected to include the SELECT * part of the string.

[michael_loop]

Try putting double-quotes around the filename when referencing a file rather than a table alias. It appears the parser is confused as to whether table.dbf is a file name or a database + table.