asked on

SQL 2000 update failed

I am updating a SQL table and get an update failed error, this worked OK yesterday so I assume there is something wrong with SQL (see attached error)
Can anyone help?
SQL-error.bmp

zvytas

Are you using linked server in your query? If so, check connection to the linked server, it seems it's down.

HKFuey

ASKER

Access tables linked by ODBC, I can open a query on the table and try to manually edit the records and I get the error. This was working OK yesterday.

HKFuey

ASKER

If I go directly to the table and try editing the field in question I get the same problem (it is not a key field)

Kelvin Sparks

Have you dropped a primay key from any of the tables - this makes the tables read only from Access. Delete and relink the tables

Kelvin Sparks

You're not by any chance linking to a view - they don't have primary keys. At the Access side you must create a unique index on the link. Normally you are asked what fields are used for the unique records when linking. It is soimetimes easy to forget when relinking that tables - or if you do it through code.

HKFuey

ASKER

I have a copy of the database I did last week and this works OK

Kelvin Sparks

The query you are using. Do it have one or more tables in it, and are any of those linked tables linking to a view?

SOLUTION

HKFuey

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION