 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / ActiveX Controls / May 2005Data type memo
I did not know just where to poet this. I hpe this is at least close. I have linked tables in my SQL server PE to a database using ODBC. The problem is that all of the data types on the linked tables is coming across as memo. They are defined correctly in the server. I am using Access 2003 on XP. Any responses are appreciated. Thanks Ken Ken If the columns on the Sql Server are defined as varchar or nvarchar AND the length is set to > 255 then an Access MDB will see the field as a Memo type as Access does NOT support a text fields whose length is > 255. As far as I am aware there is NO workaround for this. Sorry :-( Ron W > I did not know just where to poet this. I hpe this is at > least close. [quoted text clipped - 13 lines] > > Ken Ken try this article 259893 ACC2000: Formatted Memo Field Appears to Truncate Data After 255 http://support.microsoft.com/?id=259893 As per Access any TEXT field greater then 255 character is taken as MEMO Hope this helps |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.