18 questions
Issue was solved. Thanks-> There was a triggered table in the backend that was not updated with the new field size. Now it works.
In MS Access what is the maximum "length" of the field in a table with data type "long text"?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 72%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
Carrera_Carazas,Luis_Felipe (GBS GES) BIG-DE-I
0
Reputation points
Hi,
i cannot see the size of the field and i have difficulties entering data with length higher than 2500 as varchar (table from sql server).
I increased the field size to 3000 but it is not working
I connected to that table again
thanks for any input
felipe
{count} votes
-
Carrera_Carazas,Luis_Felipe (GBS GES) BIG-DE-I 0 Reputation points
2025-03-11T16:16:57.5766667+00:00 I altered the data type of the column from varchar to nvarchar as recommended by microsoft, but the change is not being applied.
-
Erland Sommarskog 119.4K Reputation points MVP2025-03-11T22:31:47.4966667+00:00 I'm sorry, but I don't understand much of what you are talking about. Can you explain more clearly what you are doing? Keep in mind that not everyone who is following the SQL Server tags has knowledge about Access.
Screenshots could help.
-
Carrera_Carazas,Luis_Felipe (GBS GES) BIG-DE-I 0 Reputation points
2025-03-12T13:51:49.3766667+00:00 Thanks. Yes, I know MS Access is not the best technology, though we have to use it.
Case: From a MS Access database file, i connect / link a table to a MS SQL Server table. In my current MS Access version I have a column with data type varchar(2500) and there is a request to extend this field size to 3000.
I updated the table in SQL Server database to varchar(3000) and also in a different test sequence as nvarchar(3000), as recommended by Microsoft. However in both cases I still cannot enter text longer than 2500 characters.
Steps done in SQL Server / MS Access:
- Updated database table column size from varchar(2500) to varchar(3000) and nvarchar(3000).
- In MS Access I connected via ODBC to SQL Server and linked the requested table again.
- I refreshed the database.
- Enter text comment with size greater thatn 2800 in MS Access form field connected to the updated table field (according to Excel length function).
- Error message from system (MS Access) ->
-
Carrera_Carazas,Luis_Felipe (GBS GES) BIG-DE-I 0 Reputation points
2025-03-12T13:54:03.9533333+00:00 Error message
Sign in to comment
1 answer
Sort by: Most helpful
-
Carrera_Carazas,Luis_Felipe (GBS GES) BIG-DE-I 0 Reputation points
2025-03-12T15:01:31.6133333+00:00 -
Erland Sommarskog 119.4K Reputation points MVP
2025-03-12T21:40:01.3466667+00:00 Great to hear that you were able to find a solution!
Sign in to comment -