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.

Jim.
0
 
hnasrCommented:
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.
0
 
PatHartmanCommented:
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.
0
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.
0
 
Steve HorthAuthor Commented:
Adding a Timestamp and making it the PK fixed it right up. THANKS !!!
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Good to hear.  

Jim.
0
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.