sql server table with long text field truncated in access

M

Muzzy

Hi everyone!

I wonder if anybody could help/explain(?) me with the following:
Say, i have the following table on sql server:
MyTable (
ContactID INT,
Comments VARCHAR(1000)
)
I link this table through an ODBC file connection to an access database.
Now i open this table in access and discover that 'Comments' field is
truncated.
But more interesting, in each record it's truncated to a different length -
one line has 343 characters left (instead of 965 char phisically), another
298 characters (instead of 626 characters)... If i look at the liked table
in design mode,
i see that Access recognized this field as 'Memo', which is correct.

Then i go ahead and instead of linking just import the table to access - the
same story, records are truncated.

Most interesting that if i copy a long string to a 'Comments' cell of this
linked table, it saves on server correctly, but still shows truncated....

I tried both Access 2002 and Access 2003, with ADO 2.8 installed.

I am stuck, guys :(
Any ideas would be highly appreciated!!!

Thank you in advance,
Andrey
 

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

Top