sql server odbc: Cannot update through ODBC -- sql server odbc

Re: Cannot update through ODBC

Sue Hoegemeier
8/19/2003 3:29:44 PM

sql server odbc:

Try relinking and make sure you specifiy the correct primary
key or unique identifiers for the tables.

-Sue

On Tue, 19 Aug 2003 15:41:15 +0100, "Raul"
[quoted text, click to view]

Cannot update through ODBC

Raul
8/19/2003 3:41:15 PM

Hi,
I'm using SQL2K and I have an Access database with linked
tables (via ODBC) to the SQL Server.
For some reason I cannot create or update records any longer.
It used to work just fine. I've refreshed the links, checked the
connections etc. but all I get is the error 3027 Can't update.
Database or Object is read only.
I haven't changed any settings on SQL server as far as I remember.
Any help would be great!
Thanks.
Raul

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.