I connect to an SQL database via ODBC but each cell in the table shows the word DELETE.

I link to a remorte SQL Server database via ODBC. It finds the table and reports the correct number of rows; however each cell shows #DELETE.
Steve HorthAsked:
Who is Participating?
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Make sure that the SQL table has a timestamp filed in it or  you will have problems.

 This turns on row versioning n SQL, and JET will latch onto that for building it's keyset cursors to access the data.

 Add the field, then delete the table link and re-add it.

 If you still have problems after that, holler.   There are a few more things that can cause this.

Someone else has just deleted the same set of records you are  currently viewing.

You can reproduce the issue even in a local database. In access, open both a table and a query, based on the same table.
Switch to table and delete a record. Switch to query to see #Deleted in query fields.
Could be that the PK of the table is BigInt.  You will have to look at the table in SSMS to determine this because Access will show it as text.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

QlemoBatchelor, Developer and EE Topic AdvisorCommented:
I get that with Access linking to Oracle, and asking for too many data at once, e.g. on fast paging, but it is accompanied by an error popup.
Steve HorthAuthor Commented:
Adding a Timestamp and making it the PK fixed it right up. THANKS !!!
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Good to hear.  

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.