Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-24 : 09:08:27
|
| Tod Thames writes "I have a SQL Server 7.0 database that was converted from a MS Access 97 db. One field in the Access db was a memo, SQL Server assigned the datatype as nvarchar, which works fine if you enter data directly through SQL Server. I however, use Access as the frontend to enter data into the SQL Server db and it doesn't work. Access connects through an ODBC connection. The table view in access shows the field as a text field with 255 characters. I need more than that, but if I change the type to ntext or text, I get errors about using a where clause.Any help is apprecicated." |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-06-25 : 07:18:30
|
| This is a bit of a guess.I don't think you can use text or ntext in a where clause. You can use varchar fields which hold up to 8000 characters or nvarchar which hold up to 4000.Try changing the datatype in Access to memo and the sql to varchar(nnnn) where nnnn is the number of characters you need. See if that works. |
 |
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2002-06-25 : 08:11:05
|
| Can this be done with a linked table? I though the ODBC link process set up the fields correctly. I would have thought with a link table you would not get an error...Me learning more and more about access by accident!!Dan<<monet makes money>> |
|
|
|
|
|
|
ODBC Connection from SQL Server DB