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