Link to home
Start Free TrialLog in
Avatar of mickeyshelley1
mickeyshelley1Flag for United States of America

asked on

Find Corrupt Record

I am trying to upsize all my access tables to sql server express the problem is that it keeps skipping one table. I suspect it may be because of a corrupt record because each time I attempt to run a query on this table I get an error that says Record Deleted. This table has 17,000 records so is there a way to find a corrupt record.
Avatar of ioane
ioane
Flag of New Zealand image

You could try printing your record id's to the immediate window and see where it fails.
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mickeyshelley1

ASKER

You were correct on the primary so i added the AutoNumber field as the primary key, the table was still skipped.
acperkins: You could try printing your record id's to the immediate window and see where it fails.  

Is this a simple procedure?
Sorry, Itried it again and it worked....Thanks
>>You were correct on the primary so i added the AutoNumber field as the primary key, the table was still skipped.<<
Perhaps you failed to refresh the linked table so that SQL Server was unaware that you had corrected the problem.
Solved my problem
Big Thanks acperkins: