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

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"
<raul@tangible-results.com> wrote:

>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
>