Table Locked??? (1 Viewer)

KACJR

Registered User.
Local time
Today, 00:21
Joined
Jul 26, 2012
Messages
81
Greetings to the well of knowledge...


I have an Access 2016 front-end talking to an SQL instance. Last week, some issues arose that required me to restore a couple of corrupted tables from backup. These tables restored successfully but since then, one of the tables appears to be in "read only" mode in Access. I gleaned this by opening the table in Table view and found that I could neither append nor delete records from the table. It appears that the table is locked. I can edit existing records.



Any ideas how to get out of this and get the tables back to normal?



Thanks,
Ken
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:21
Joined
Oct 29, 2018
Messages
21,322
Hi Ken. Do the tables have a Primary Key assigned? If so, try deleting the linked tables from Access and then relink them and see if Access asks you to select the PK field.
 

KACJR

Registered User.
Local time
Today, 00:21
Joined
Jul 26, 2012
Messages
81
NAILED IT! How did you know????
 

Users who are viewing this thread

Top Bottom