Can somebody please help me. I've got a SQL Server database, with an Access front end. Some of the linked tables can be edited and some not. Yeah....I know they are read only, but how do I get rid of the read only property?
I have created the table on the server so that everybody has permission to read and write to this table, but when you open the table as a linked table in Access you cannot add anything to the table. According to Access the table is read only(I have restarted SQL server as well, and relinked the table...nothing helps)