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
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