Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 3 down vote favorite
1

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

share|improve this question
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

1 Answer

up vote 4 down vote accepted

It looks like the linked MSSQL 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 MSSQL table. Click here for more detailed info.

share|improve this answer
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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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