Memo filed in SQL-server with Access 97

A

Ardeshir Amini

I am using Access 97 as the front end and SQL Server 2000 on the back end. I
have a few fields in SQL that have more than 255 chars. The fields are
defined in SQL as nvarchar with a size of 1000. However, when I open the
linked table in Access, it only shows the field with 255 chars. It shows
#Error in other records. Therefore, I get an error that the text is too
large for the field.

I would just change the field from "text" to "memo" in Access. SQL does not
have a problem storing the info, but Access can not display it if it is
larger than 255 chars. I have tried also other types as Text, nText without
success.

I have no problem viewing the data in Access 2000.

Ardeshir Amini
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Truncating SQL Server "Text" field 5
Truncation of memo fields using DoCmd.TransferText acImportDelim, 1
Extracting Long String Fied from SQL Server to Access 2003 5
Export Problem 1
EXPORT QUery with memo field to excel, truncated data 2
Upgrade 2007 accdb database to SQL server 2005 or 2008 8
Linked table column type changes from text to memo 1
Append to SQL Server 3

Top