asked on

can't edit linked sql table in access

Hi, can someone please tell me why access linked table is not allowing to edit(can't update, delete,insert)?
i have couple of sql tables which are linked in access form. all my tables can be edited except 1 table.
don't know reason why..i can edit table in sql db but not in access db

please note that sql table is having primary key as well

ASKER CERTIFIED SOLUTION

John Tsioumpris

membership

This solution is only available to members.

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

Start Free Trial

LISA GEORGE

ASKER

yes john my table has primary key but i am not sure what is this timestamp column

John Tsioumpris

Check this for timestamp: https://sourcedaddy.com/ms-access/timestamps-and-row-versioning.html and also it would be a good idea to remove the problematic table and relink it... probably you picked the wrong column as key

LISA GEORGE

ASKER

thanks for that link John and your quick response..will have a look on that. but yes i did deleted that table and relinked it but sill problem exists.
i even dropped table in sql and created again

John Tsioumpris

Strange... maybe your key is problematic...what if you use one of good table...make a copy of it and work your way to get it to have the same fields as the one you want ...

SOLUTION

Anders Ebro (Microsoft MVP)

membership

This solution is only available to members.

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

Start Free Trial

SOLUTION

ste5an

membership

This solution is only available to members.

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

Start Free Trial

LISA GEORGE

ASKER

thank you all for your time and answers. i really appreciate for your help and time
there was problem with primary key which i created earlier
but later i had deleted and recreated again with some modifications in sql and it's working now
thank you once again

LISA GEORGE

ASKER

@anders @ste5an

i didn't got any error messages. problem is with key i created so later when i recreate that again, everything seems good
thank you guys