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