Linked SQL Table not allowing Insert
Posted on 2006-07-06
I have a SQL table linked into my database as I have done many times. The table was first created in Access and imported to SQL 2005. I created an ODBC connection and linked the table.
I can see the data on the table, but for some reason, I cannot add records. I get error: Insert Permission Denied. I have many other tables with other Access databases linked to the same SQL database. The permissions are all the same for all SQL tables on this database.
I can't figure out what is specic about this table and why it won't let me add records.