In MS Access what is the maximum "length" of the field in a table with data type "long text"?

Question

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

Answer 1

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:

1. Updated database table column size from varchar(2500) to varchar(3000) and nvarchar(3000).
2. In MS Access I connected via ODBC to SQL Server and linked the requested table again.
3. I refreshed the database.
4. Enter text comment with size greater thatn 2800 in MS Access form field connected to the updated table field (according to Excel length function).
5. Error message from system (MS Access) ->

Answer 2

Error message

Answer 3

Issue was solved. Thanks-> There was a triggered table in the backend that was not updated with the new field size. Now it works.