MySQL Forums
Forum List  »  Microsoft Access

Advanced Search
New Topic

Re: Link Breakage using MS Access as frontend to MySQL server
Posted by: Bryce Larsen
Date: January 17, 2022 05:58PM

Hi Peter, Thanks for the quick response.
Yeah, that's what I meant, one table with 1286 rows, and yes I can query it directly from a MySQL command line client. The error message Access was giving said 'ODBC--call failed'.
Now here's where I get to admit what I guess was a foolish mistake on my part. I was doing some further checking trying anything from the trace file that I thought could be a pertinent error code and found something suggesting that users must use the unicode ODBC connector. Sure enough, changing to that appears to have fixed the problem.
Thanks so much for your time!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Link Breakage using MS Access as frontend to MySQL server
756
Bryce Larsen
January 16, 2022 09:38PM
Re: Link Breakage using MS Access as frontend to MySQL server
364
Peter Brawley
January 17, 2022 06:11AM
Re: Link Breakage using MS Access as frontend to MySQL server
433
Bryce Larsen
January 17, 2022 05:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.