Memo field problem using Access97 with SQL2000 Backend
This is a discussion on Memo field problem using Access97 with SQL2000 Backend within the SQL Server forums, part of the Microsoft SQL Server category; --> I have an application written in Access 97 that connects to a SQL2000 backend. One field is a description ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:08 PM
| ||||
| ||||
 Memo field problem using Access97 with SQL2000 Backend I have an application written in Access 97 that connects to a SQL2000 backend. One field is a description field that is a data type NTEXT in the SQL database. In my access form, I can not enter more than 255 characters. Before I converted the backend to SQL, the description field was a memo field in Access. What do I need to do to make it so I can enter more text into this field?      |
|
02-28-2008, 07:08 PM
| ||||
| ||||
| Re: Memo field problem using Access97 with SQL2000 Backend NChar, NVarChar, and NText are double-byte unicode types. For example, nchar(10) will hold 10 bytes of data but takes 20 bytes of space. Convert the field's datatype to Text and you should be fine. Look up "data types-SQL Server, described" in Books Online for more info. "Bob" <bobh@wolv.tds.net> wrote in message news:<vta8f56bkredfd@corp.supernews.com>... > I have an application written in Access 97 that connects to a SQL2000 > backend. One field is a description field that is a data type NTEXT in the > SQL database. In my access form, I can not enter more than 255 characters. > > Before I converted the backend to SQL, the description field was a memo > field in Access. > > What do I need to do to make it so I can enter more text into this field? |
Linear Mode
