Application Crashing.....????

[asmodius]

O.k. so this will probably end up being something the pros that run this forum are going to have to fix for my company but I figure worth a shot posting to see if I get anything that I can do to fix this issue.

We have a QA database that has been running for months right now. Recently a record was somehow input into one of the tables and it is corrupted. I know this because if you open the table as soon as it you scroll down to the record, somewhere near the bottom, the application shuts down, brings up an error report and tries to backup the database. I have tried many different methods of deleting this record, once I even managed to highlight the record and click delete record. Only to have the application say that the search field could not be found. It seems to me the only way I am going to resolve this is to export all the records but that one, if possible, or delete that record somehow. Although I don't know how that would be done. Compact and repair crashes, DBRepair crashes, and access recovery doesn't load the ouput tables for some reason. Any ideas?

Thanks.

 

[dgm]

Have u tried using the Jet Compact Utility?

Or exporting that table, or importing it into another database?
Maybe you could make a query that selects all records except that one and create a new table with that data?

When i've had a corrupt record, i've found i've been unable to delete it until after i've ran a compact and repair.

Other then that i'm not sure...

Good luck!

 

[asmodius]

failed...

JetComp fails too. I like your query idea though. You're saying use a query to export all the records except the bad one to another database right? by linking the table? Let me know if thats what you're thinking, although I am going to try that anyway.

thanks,

andy

 

[asmodius]

Corrupted Record Fix.......

So I had to do a weird little set of procedures to get that to work and I thought I would list them here for future newbies.

To remove a corrupted record that cannot be removed any way this is what you do. I am assuming here you know which record is the corrupted record.

1. Rename corrupted table to something else

2. Import that corrupted table back into the same database with a different name, and with STRUCTURE ONLY in the import options. This will not work if you try to import the data too.

3. Create a new blank query in design view

4. In query type drop down select "append query" and point it to the new blank table

5. Show the corrupted table.

6. Select all items from that table and bring them down into the query.

7. For the record number field set a criteria that is <record#>

8. Run the query and have it append the data to the blank table

What you should have now is a new table with all of your old records except one.


Thanks.