Unable to edit SQL Server tables in Access database

[awhitsel]

I have an Access database which I recently upsized to SQL Server using the Upsizing Wizard.

When I link to these tables in another Access database, the tables open up OK, but the data is read-only. I can look at the tables in SQL Server, and they are read-write there.

Is there a way to move an Access database to a SQL Server database and keep them as read-write?

Please advise.

Thanks.

 

[RobertT687]

In order for a linked table to be updatable in Access, the table must have a Primary Key defined in SQL server.

 

[dhookom]

Once the primary keys have been defined on SQL Server, you will need to relink the tables in Access in order for Access to identify the keys.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]