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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hamed NasrRetired IT ProfessionalCommented:
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
Qlemo"Batchelor", 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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.