#Deleted Problem with MS Access and MS SQL
Posted on 2013-05-10
I'm using MS Access 2000 as my front end and MS SQL Server as the backend (I believe it is 2008 R2).
I have a table with 3 million record that is giving me trouble. At least part of the table has become currupt and the prhase #Deleted now appears in every field of a specific row.
The problem record can be displayed if I run this query:
SELECT CompPricing.Manufacturer, CompPricing.*
WHERE (((CompPricing.Manufacturer) Like "*hHQp*"));
However, when the query results appear the work #Deleted appears in every field.
If I attempt to delete the row from the query, the system acts as it would if I were actually deleting a row, except that no deletion ever takes place.
I'm using ODBC to connect to the MS SQL Server.
I logged into the MS SQL server and attempted to manually delete the record.
As before, the system responded as it would if the record was deleted,
although no deletion took place.
The deleted record is causing other routines to fail so I can not ignore it .