ODBC-linked table update on table ' table name ' failed.

[Katuil Katuil]

Hello All:

Have a problem that I have never seen before and have not found anything
on
technet on how to resolve it. I have a SQL Server 2000 server that I
have
created a new database. I then used DTS to import data from a MS Access
97
database. Before making the import, I made changes to the MS Access
database
and changed the autonumbers to integers. I also removed all
relationships.
My front end is still in MS Access 97 and I am linking ODBC tables from
the
SQL Server. Here's the issue, I can not make any changes to any data in
any
table. I get the following message:

ODBC-linked table update on table 'Registry' failed.

According the help for this, the database is in read-only mode. I
checked
the MS Access front end and all my settings on the SQL Server. Nothing
is in
read-only. I did not use the Linked Table Manager to relink the tables,
which can cause issues.

After this message I get the following message:

The text, ntext, and image data types cannot be compared or sorted,
except
when using IS NULL or LIKE operator.

Which is error 306 and has a severity of 16.

On the same SQL Server using Northwind I do not have any issues. Any
ideas
would greatly be appreciated. Thanks.
Katuil

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!