link SQL Server

[yuchieh]

I created a system datasource and linked tables from a SQL database into Access. I couldn't change any data in Access; it says "recordset is not updateable". However I did the same with other SQL database, linking tables into Access. And there is no problem updating information in Access.
What could possibily cause the problem updating records of that database in Access?

Thanks.

 

[cmmrfrds]

The SQL Server tables need a unique index to be updateable from Access. Do you have a primary key for the table(s).