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 - 2003-10-21 : 07:53:46
|
| Syed writes "Hello:We have created a link to a SQL 2000 table within Access 97. If I drop all constraints on the table in SQL, I can see the data in Access, but as soon as I add a primary key, all the data in Access shows up as #Name? And I get a message that says "ODBC Call Failed"The problem has to do with two large varchar fields that are of length 2000. If I drop these fields from the table in SQL, then I can see all the data in Access.Does anyone know how I can view/update large varchar fields in a linked table?" |
|
|
mharvey
Starting Member
13 Posts |
Posted - 2003-10-22 : 15:25:09
|
| Hello Syed,You might try to change the data-type in the SQL Server to "nText". After which, you might also try running the sp_TableOption stored procedure to allow the text to reside in each row, thereby eliminating having SQL Server store large amounts of text in extents.Here is a code sample to set the text in row option for the 'orders' table to 'ON':EXEC sp_tableoption 'orders', 'text in row', 'ON'(Note use of lower case for the argument and upper case for value.Good Luck,Michael |
 |
|
|
|
|
|
Linked SQL Server 2000 table in Access 97