Access front end - table not found 1

[tr1976]

Hi
Im trying to move the backend of an Access 2000 database over to MySQL, however queries are running very slowly (more slowly than just Access even). Running the same queries from outside Access is much faster, and so ive been trying to use a pass through query to pass it straight to the MySQL server. However, with a query like

SELECT * FROM Invoices

Im getting an error message

The Microsoft Jet Engine cannot find the input table or query 'Invoices'. Make sure it exists and that its name is spelled correctly.

Despite the error message, the correct field names are displayed, albeit with no data. So the table must be found OK... I thought that pass through queries were supposed to bypass the Jet engine...

Any help much appreciated
Thanks

 

[QatQat]

you still need Ms Jet to display data back to Access.

I had that problem; my solution, I changed myODBC version and everything was solved.


Bye

Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)