patternsqlMinor
MS Access displays alle columns in SQL Server tables as "deleted"
Viewed 0 times
tablescolumnsdisplayssqlalledeletedserveraccess
Problem
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.
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.
Solution
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.
Context
StackExchange Database Administrators Q#3158, answer score: 5
Revisions (0)
No revisions yet.