MYSQL Connection on AWS

[ions]

Hello MS Access Expert,

I didn't know what section of the forum to post this question, so I decided to post it here.

I have a friend who has a MYSQL database on AWS. I was able to Migrate his MYSQL Database to my local instance of SQL Server using the Migration Assistant for MYSQL successfully.

I now want to re-link the tables directly to MYSQL on AWS. I am able to create the Table Links successfully to AWS but when I open the table Links I receive an ODBC error and no data is received. (Please see the below Screenshots) I am surprised I was able to successfully Migrate the Data from AWS to my local SQL Server but I am having errors accessing the data from MS Access.

Any advice would be appreciated.

Thank you

ODBC Drivers Installed.

 

[cheekybuddha]

Someone on UtterAccess had a similar problem here. The OP there hasn't come back with a solution yet.

Perhaps a problem with the new MyODBC driver?

Have you tried with a 8.x.x version of the driver?

Also, AWS have produced their own fork of the driver here which might be worth testing if all else fails.

 

[ions]

Thank you CheekyBuddha.

I appreciate your response. It looks like it's probably a driver issue. I'll try the 8.0 version later this afternoon.

 

[Josef P.]

Maybe you have Access 32 bit and the ODBC driver is for 64 bit.

 

[cheekybuddha]

Maybe you have Access 32 bit and the ODBC driver is for 64 bit.

I wondered that, but I think it would not show up in the list of drivers when creating a dsn, or cause a more fundamental error at runtime

 

[ions]

I downloaded ODBC MYSQL 8.3 64Bit from the below website and everything is working now.

Thank you CheekyBuddha!

https://downloads.mysql.com/archives/c-odbc/

 

[cheekybuddha]

You're welcome. Glad you got it sorted!