MS Access displays alle columns in SQL Server tables as “deleted”

I have created an ODBC connection to a SQL Server 2005.

When I link to the tables from MS Access, some tables have only “deleted” data.

This means the rows and columns are displayed, but all data seems “deleted” (“Geloscht” in the image)

I find it remarkable that some of the tables of the same database work fine.

It looks like the linked SQL Server table does not have a unique index on in. MS Access uses the MS Jet DB engine that is designed around a keyset model. Actions like inserts, updates, etc, uses this keyset. This may be missing from your linked SQL Server table. Click here for more detailed info.