Linked SQL 2005 Tables are READ ONLY in Access

[chiplarsen]

Hi, I have an Access 2003 database that uses SQL 2005 linked tables. I have no problem opening the database and viewing the data, but if I want to add a record to the table or update a record, I can not do it. The options to insert a record are grayed out. The SQL tables are linked via ODBC back to the SQL database. The tables seem to be able to be updated via Access queries, but no directly in the table. Has anyone ever had this type of problem?

Thank you

 

[dhookom]

You haven't told us the basics like if you as a user have permission to add or edit records. Also, does the SQL table have a primary key? If so, does Access know about it?

Duane
Hook'D on Access
MS Access MVP