can't edit linked  sql table in access

LISA GEORGE
LISA GEORGE used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software & Systems Engineer
Commented:
Does your table has a primary key... absolutely a must in order for Access to know how to handle the table and also a timestamp column to get proper "timing"
Probably this question should also carry the tag "Microsoft Access"
LISA GEORGEMICROSOFT DEVELOPER

Author

Commented:
yes john my table has primary key but i am not sure what is this timestamp column
John TsioumprisSoftware & Systems Engineer

Commented:
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
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

LISA GEORGEMICROSOFT DEVELOPER

Author

Commented:
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 TsioumprisSoftware & Systems Engineer

Commented:
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 ...
If you open the table in design view (from Access, just ignore the warning that can't change anything) has it picked up the the correct primary key?

Are you getting any error messages?
ste5anSenior Developer
Commented:
The linked table must have columns marked as primary key in Access. It's not necessary that the table on the SQL Server has one.
Also the columns marked as primary key must be of a precise data type, e.g. no double.

Do you have INSERT, UPDATE, DELETE permissions on that table on the SQL Server side.

And my favorite: Depending on the columns involved, sorting the data in a grid view can make Access think it's no longer updateable. The trigger is to sort on the Access side over a Memo (Long Text) column.

And what are the exact symptoms? Error messages or just a hint in the bar?
LISA GEORGEMICROSOFT DEVELOPER

Author

Commented:
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 GEORGEMICROSOFT DEVELOPER

Author

Commented:
@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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial