having reserved error (-1524) how to remove corrupt data from access

[mugheesee]

i am running a querry on my data base and it giver reserved error(-1524)

on searching on internet i found out that it is due to some corrupt data in the DB .
My DB is of more than 600000 enteries so i cannot check them one by one by scrolling

i there any other way that i can remove the corupt data or remove this reserved (-1524) error.

i even tried to use append querry but it again shows the same error

[jforbes]

I've never run into this error, but if I do, this is what I would try:

• Create a new database and import all as many objects as possible into. Most likely the corrupted data will prevent at least one table from importing.
• Link to the tables that did not Import.
• Rename the Linked tables and append _Old to the end so that the new tables and old tables can be differentiated.
• Create a Make Table Query with the _Old Tables as the Basis, Choose a Star(*) as the selection set and use "1=2" for the Criteria, so that no records are actually selected, effectively creating a New Blank table. Here is an example:

SELECT Contacts_Old.* 
INTO Contacts_New
FROM Contacts_Old 
WHERE 1=2

• Open the _New table up in Design mode and verify the table structure, especially any Keys, like the Primary Key.
• Then I would create a query to insert a range of records from the _Old table into the _New Table:

INSERT INTO Contacts_New
SELECT Contacts_Old.*
FROM Contacts_Old
WHERE Contacts_Old.ContactID>0 AND 
Contacts_Old.ContactID<99

• If the Query executes, then Increment the range in the Where clause to include the next 100 or 1,000 or so records and attempt to run the Query. Eventually the Query will error, or Access will shutdown. This will signify that corruption lies within the last selection set that was attempted.
• Now start again inserting records from the _Old table into the _New table, but with a smaller range of records to narrow down the list of possible bad records.
• When the range of possible bad records is small enough, open the _Old table in view mode and scroll down to the troublesome records and have a look.