MS Access data conversion - Re: ODBC function sequence error after converting from Acc 97 to A

Author

Re: ODBC function sequence error after converting from Acc 97 to A

Darren Burns

2005-11-01, 9:24 am

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.

"Douglas J. Steele" wrote:

> 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
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Darren Burns" <Darren Burns@discussions.microsoft.com> wrote in message
> news:17F65014-481F-4CDB-9DD0- 15B572770367@microso
ft.com...
>
>
>

Sponsored Links