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

Next, I would try select a single, simple field in a pass-through rather than all fields. 

Duane

Sent from my mobile

On Aug 2, 2023, at 12:23 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Yes, a simple table with just 2 field and few data, is connected via pass through query without any errors.

regards

Ahmed

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

Did you try with a very simple table?

Duane

On Aug 1, 2023, at 1:01 PM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane

I think now i understand what you meant, tried the pass through query with ODBC connection string:

<image.png>

tried both File DSN and Machine DSN with same following error:

<image.png>

regards

Ahmed

On Tue, Aug 1, 2023 at 10:42 PM Ahmed Hashim via groups.io <ahmedhashim1=gmail.com@groups.io> wrote:

Duane,

How do I create a pass through query from Ms.Access without connecting/Linking to MySql? I am trying to link with only 1 table. With no relationship with any other tables etc.

regards

Ahmed

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

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