By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

Access 2000 + MySQL

jenkinsloveschicken
P: 56
I am needing to query a MySQL database for my latest project. I attempted to link to the table with the ODBC 3.51 connector and was successful. However, when the MySQL database was built, 3 of the critical fields were collated to UTF8-bin, which unfortunately from everything that I've found Access cannot interpret. It displays the data as OLE Object.

I have incorporated the connection to the form load property of my main form, however at this point I am over my head and need some help. Is it possible to execute the query to the MySQL table and have it retrieve the contents of the UTF8-bin fields? The reason I am attempting to do it this way is because changing the data types in the database will result in a large amount of data loss as it has been tested already.

If it is possible, can someone provide me a syntax structure for something to begin with?

Thanks in advance,
Gerald
May 18 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,489
Gerald, I'm guessing that the other Access Experts (like myself) don't have the relevant experience of the ODBC connection to a MySQL database. You could try in the MySQL forum, but it would need both I expect, to help with this one.
Jun 2 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.