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.

enter image description here

  • This question deserves a +1 as well because this is a common occurence that @Stan the Man pointed out. All Access VBA developers should concur with this, and all others should be made aware of this by means of your question. – RolandoMySQLDBA Jun 6 '11 at 14:29
  • @jcolebrand: I would expect the content of the cells instead of the word "deleted". There is no such thing as "deleted" cells involced in the setup. Either tabel rows are or they are not. – mit Sep 12 '11 at 18:40

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.

  • 1
    @mit I have seen this too in my developer days. This one hits the nail on the head !!! +1 for Stan the Man !!! – RolandoMySQLDBA Jun 6 '11 at 14:27
  • thank you, I was already suspecting it got something to do with unique indexes. When i linked the tables MS Access asked me about unique indexes. I will follow your link. – mit Jun 6 '11 at 19:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.