• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

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.
0
mickeyshelley1
Asked:
mickeyshelley1
  • 5
  • 2
1 Solution
 
ioanePlanning & Analytics ManagerCommented:
You could try printing your record id's to the immediate window and see where it fails.
0
 
Anthony PerkinsCommented:
I suspect the table does not have a Primary Key, right?  If not, add one.
0
 
mickeyshelley1Author Commented:
You were correct on the primary so i added the AutoNumber field as the primary key, the table was still skipped.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
mickeyshelley1Author Commented:
acperkins: You could try printing your record id's to the immediate window and see where it fails.  

Is this a simple procedure?
0
 
mickeyshelley1Author Commented:
Sorry, Itried it again and it worked....Thanks
0
 
Anthony PerkinsCommented:
>>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.
0
 
mickeyshelley1Author Commented:
Solved my problem
0
 
mickeyshelley1Author Commented:
Big Thanks acperkins:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now