query returns "DELETE" as field value

[Randy]

I have a query, and when I execute it, the correct data set is returned. However one field shows "DELETE" as the value for all records.

when I ran it on the SQL server management studio as a test it ran fine. End user does not have access to the tables, so I created a small MS Access application. When I ran the query in MS Access, then connected table dbo_DocRef > Notes shows a value of DELETED.

See attached screen shots. What am I missing?

 

[JHB]

What do you get if you open dbo_DOCUREF table in MS-Access, just before and after you've run the query?
Create a query only based on dbo_DOCUREF and run it, what do you get then?

 

[Galaxiom]

It could be a datatype incompatibility between SQL Server and Access.

What is the version of SQL Server and the specification on that field?

 

[Randy]

great question, I never opened the table in MS Access. In fact it shows DELETE for every record every field. I have never run into this before.

 

[Randy]

I did determine the issue. The SQL table is way to large for MS Access. over 11 million records. I created a SQL view and attached the MS Access to that view and worked like a charm.

 

[JHB]

Good you got it solved.