I have an access database which connects to a series of tables on a SQL server. Each time the database is open All tables are linked using a function to create a DSN Less tables.
But when I go to add or edit records, some tables allow this, others allow no edits or additions (yellow star at bottom is greyed out).
The same function is used to link all tables, so I am assuming the issue is not with access.
I can add/edit all tables using TSQL in SSMS. I am no expert in SQL SERVER, but looking at properties/permissions between a table that allows edits in Access and one that doesn't they look the same.
It's driving me a bit mad, any help would be appreciated.
But when I go to add or edit records, some tables allow this, others allow no edits or additions (yellow star at bottom is greyed out).
The same function is used to link all tables, so I am assuming the issue is not with access.
I can add/edit all tables using TSQL in SSMS. I am no expert in SQL SERVER, but looking at properties/permissions between a table that allows edits in Access and one that doesn't they look the same.
It's driving me a bit mad, any help would be appreciated.