Re: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

Did you attempt the pass-through query in Access? There might be an incompatibility issue with one or more fields. Can you try link to a very simple table?

Duane

On Aug 1, 2023, at 10:24 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane,

Surprisingly Excel is able to get connected with MySql and even import data via ODBC without any errors.

regards

Ahmed

On Tue, Aug 1, 2023 at 6:27 PM Duane Hookom <duanehookom@hotmail.com> wrote:

I would try create a pass-through query or connect via Excel (as tests). 

Duane

Sent from my mobile

On Aug 1, 2023, at 7:47 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Yes, creating DSN outside Ms.Access is successfully connected with MySql database:

<image.png>

On Tue, Aug 1, 2023 at 4:59 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Creating an ODBC/DSN can be accomplished completely outside of Access. Is this successful? Will the DSN connect?

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Ahmed Hashim <ahmedhashim1@gmail.com>
Sent: Tuesday, August 1, 2023 12:52 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

 

Hi to All,

I am trying to connect and link Mysql table with Ms.Access, but everytime using wizard it shows following error:

<image.png>

I've tried via ODBC (file, system and machine DSN), and received the same error every time.

Environment Information:

Windows 10 64bit

Ms. Office version 2019 64bit

MySql version: mysql  Ver 15.1 Distrib 10.4.20-MariaDB, for Win64 (AMD64), source revision c7ee039d36f69f24fb3b1c422fcff8dbf974e3eb

MySql ODBC Driver/Connector: MySQL ODBC 8.1

Any help/suggestion will be highly appreciated.

best regards

Ahmed Hashim