I need help once again...

I have a database that has one main table for most of it's data. For
some reason, it looks like two of the records have been corrupted...
because of these recoreds, the table cannot be opened in Datasheet view
(get an "invalid argument" error before it fails to open), and any
attempt to repair the database or copy the table results in the entire
Access session to crash and an error report to be sent. Attempt to
export the table have the same result.

I should also mention that the table MSysCompactError comes up, showing
entries with error codes 1003, 1017, and 1053. Each entry notes has
the "Could not find field 'Description'." in the description field.
The table that I'm working with does not have a field by that name. I
presume these errors are from my attempts to compart and repair.

I have a form that view individual records, and when I scroll through
those records there are only two that cause the form to hose up with
strange characters and Invalid Data (#error) notices. I'm thinking
that if I can find a way to kill those two records, I may be able to
salvage the rest of the data. How would I go about doing this without
opening the forms or table?

I should also mention that I have the record numbers for the two
records that seem to be hosing everything up... I'm not sure if I could
somehow reference those record numbers using some sort of form/code to
have it delete those specific records.

At times like this, nothing beats a good backup.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Bassthumpa" wrote:

> I need help once again...
>
> I have a database that has one main table for most of it's data. For
> some reason, it looks like two of the records have been corrupted...
> because of these recoreds, the table cannot be opened in Datasheet view
> (get an "invalid argument" error before it fails to open), and any
> attempt to repair the database or copy the table results in the entire
> Access session to crash and an error report to be sent. Attempt to
> export the table have the same result.
>
> I should also mention that the table MSysCompactError comes up, showing
> entries with error codes 1003, 1017, and 1053. Each entry notes has
> the "Could not find field 'Description'." in the description field.
> The table that I'm working with does not have a field by that name. I
> presume these errors are from my attempts to compart and repair.
>
> I have a form that view individual records, and when I scroll through
> those records there are only two that cause the form to hose up with
> strange characters and Invalid Data (#error) notices. I'm thinking
> that if I can find a way to kill those two records, I may be able to
> salvage the rest of the data. How would I go about doing this without
> opening the forms or table?
>
>

Fortunately for me, I did a backup at the beginning of the month, and
didn't even remember doing it. WHEW! I should be able to use my
working form to save the rest of the records except the two corrupt
ones.

I'm still wondering what caused the table to bork itself in the first
place. I'll dig into those links and try to learn a few things to
prevent it from happening again.

Blast... won't be that simple, as the sort order of the tables was
changed somehow. Well, at least it'll be working for the most part
again.

Ok, I created a new database and linked to the tables of my old one.
It was able ot open the data table, but not able to delete the borked
records... so I just created a new table, copied all of the records
except for the two bad ones, delete the bad, rename the good, and I'm
back in action!