ODBC function sequence error after converting from Acc 97 to Acc 2

[Darren Burns]

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?

 

[Douglas J. Steele]

Do the pass-through queries work by themselves? If not, try recreating them.
If they do, try recreating teh Append queries.

 

[Darren Burns]

Thanks for your suggestion Doung but unfortunately I still cannot get the
queries to work. The pass-through queries do work by themselves but when I
recreated the query it still did not work.

I should have mentioned that the tables I am trying to append to are linked
tables to another access 2000 database. I can insert into a local table OK by
selecting from the pass-through query. Its the combination of inserting into
a linked table by selecting data from a pass-through query which does not
work. Although it worked fine in Access 97.

Do the pass-through queries work by themselves? If not, try recreating them.
If they do, try recreating teh Append queries.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

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?