mickeyshelley1
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.
You could try printing your record id's to the immediate window and see where it fails.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You were correct on the primary so i added the AutoNumber field as the primary key, the table was still skipped.
ASKER
acperkins: You could try printing your record id's to the immediate window and see where it fails.
Is this a simple procedure?
Is this a simple procedure?
ASKER
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.
Perhaps you failed to refresh the linked table so that SQL Server was unaware that you had corrected the problem.
ASKER
Solved my problem
ASKER
Big Thanks acperkins: