Share via

For MS Access Error Message: ODBC call failed. String or binary would be truncated #8152

Carrera_Carazas,Luis_Felipe (GBS GES) BIG-DE-I 0 Reputation points
2024-10-11T11:50:23.4233333+00:00

Dear all,

I have a MS Access DB Form (mask) and a "comments" field in the mask connects to a SQL Server db table field of 2500 length. I extended the length to 3000 char as per request and refreshed the connection, but the user still cannot enter text longer than 2500 charachters.

Do you know what steps I am missing? thanks

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
880 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 44,931 Reputation points
    2024-10-11T16:41:19.23+00:00

    connects to a SQL Server db table

    And how is MS Access connected to that SQL Server database table? Have you refreshed that connection?

    0 comments
  2. Tom van Stiphout 1,696 Reputation points MVP
    2024-10-11T18:54:03.47+00:00

    You said "refreshed the connection"
    That's a bit vague. Using Access terminology, you must refresh the link to that table.
    In table design view, it should then show the length of 3000.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.