The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data

I'm using MySQL Database and using MS Access as a frontend for reporting and gathering data by linking to the MySQL existing tables

When I import the data from the tables, I can display the data without any problem. When I link to the tables using an ODBC connection and try to view the table, I get the following error:

The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

Microsoft Access can't open the table in Datasheet view."

I was expecting to be able to work with the data as is.

I am not inserting or pasting any data. I have checked the data types and they match, no field is larger that 255 Characters

I have tried different Data base connection settings, like:

• Return matched rows instead of affected rows
• Return SQL_NULL_DATA for zero date

I've tried different ODBC Connectors from 8.4.0 to 5.3.0 with no luck.

I've tried different settings in MS Access like

• Support Large Number (Bigint) Data Type for linked/Imported Tables
• Support Date Time Extended (DateTime2) Data Type for linked/Imported Tables

Pass-Through queries Comment from xShen solved my issue. sorry for the late response.