|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
After converting an Access97 database to Access 2000, the append queries do
not work
The append queries select fields from pass-through queries that use an ODBC
connection to an external database.
The queries are of the form .
INSERT INTO myTable ( field1, field2, ...)
SELECT DISTINCTROW passthru-query.field1, passthru-query.field1,...FROM
passthru-query;
The error returned is always [Microsoft][ODBC Driver Manager] Function
sequence error.
Is there any way to get these queries to work in Access 2000?
|
|
|