Record won't update in linked table 1

[SQLSister]

I have a linked SQL server table. I can add records to the table but not edit them. Also it will not let me delete records.

If I try to edit I always get the message about this record being edited by another user. I thought at first it was something funny on my form, but I can't edit records even within that table if I open the table. I can do this for all my other tables which are linked from the same database with using the same DSN.

I checked the permissions on the table and the users definitely have edit and delete rights. I can edit the records in Query analyzer or through Enterprise Manager, so the table itself is editable just not in Access.

There's nothing complex about the table just 7 fields, one is the PK and an autonumber field. Only one index presently on the table (on the pk), no triggers. Nothing odd at all about the table to make it not editable.

I tried dropping it and linking to again again to see if thare was a glitch in the link, but still cannot edit it. I tried creating the same table under another name and linking it, still can't edit or delete

Any ideas what else to try?

Questions about posting. See faq183-874

 

[PHV]

Does Access has a PK in the linked table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SQLSister]

yes

Questions about posting. See faq183-874

 

[PHV]

Have you tried to add a timestamp field in the SQL Server table and then relink ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SQLSister]

Thanks, that worked. But I don't understand why it needed that when I already had a primary key to ensure record uniqueness. I can update other tables which do not have a timestamp field.

Questions about posting. See faq183-874

 

[toeter]

What I know, is that you can't edit a table when it is opened by another operation...

Try to close connection first

build new command
delete operation
close command

build new command
update operation
close command