 |
 |
I orginally took Laurence Bates idea and it seemed to work like a charm, until someone discovered that a lot of data was missing. Upon further investigation, it seems that this corrupted database will not display all the datafields. However, the datafields show in our form, just not in the datasheet view, which is what I need to copy the records. What I did was to copy the structure from the the table with the bad record, and the structure copies fine, but the datasheet view does not show all the data because of the corruption. I tried again to hex edit out the bad record, but that is not working either. Does anyone have a good MDB recovery tool (besides the built in Access repair which does not work), or can recommend another solution? PM - James Madison College Laurence Bates wrote: >I have seen this also and sometimes managed to get around it by copying all >of the records before and after the corrupted few records and creating a new >table. > >-----Original Message----- >From: MSU Network Administrators Group [mailto:[log in to unmask]] On >Behalf Of Peter J Murray >Sent: Thursday, August 12, 2004 3:02 PM >To: [log in to unmask] >Subject: [MSUNAG] access 2000 database corruptions > >I'm having a bizarre problem with a 6,000 record access database. Once in a >great while, one record gets corrupted so badly that you cannot: >edit it, delete it, compact the database, or repair the database,and it just >causes Access to hang if you try to compact it. The record in question >causes various errrors such as 'unable to find index', and when you quit out >of the record it asks to continue running scripts. Yes, and the record >stays on the screen, and if you press no, it errors out and hangs. The >record itself has weird characters in it. (Access 2000). > >Last time this happened, I used a hex editor and zeroed out the problem >record, and was able to repair the database with only losing a few records. >Does anyone have any idea: a) why this DB is getting corrupted (multi user >environment), and b) a better way of getting the problem record out? > >PM - James Madison College. > > >