I have a SQL Server 2005 Mgmt Studio and use Access 2007 as a front-end to edit linked tables in a SQL database.

Some tables in the database I am able to edit (and add records) in Access, but others I am unable to. This may be more of a SQL Server question, but how to do I grant write access to these tables?

Thanks in advance...

First thing is that, in order to update, add, or delete records the table has to have a primary key defined. I'm betting those you can't update don't have a primary key. Once you add those in SQL Server, then use Linked Table Manager to relink the tables and then all should be well.

Yeah after fishing around on the interweb a little more I figured it out. Thanks.