[AccessD] Corrupt records-COMPLETE

Hi Mark

Nice! Thanks.

/gustav

>>> markamatte at hotmail.com 05/05 5:30 pm >>>
Hello All,

The approach I took actually worked...so I thought I'd share.

A97 mdb said it needed to be repaired...after repairing it said someone
else 
was trying to edit the same data.  I could not compact or open any
forms.  I 
also could not copy, export, import, delete, or do anything to a couple
of 
the tables.  I've seen this type of corruption before and immediately
went 
to the MEMO fields...where I found a number of corrupt records.  Again
I 
couldn't edit, delete, or do anything to these records. So...I opened a

recordset with the caseID and LEN(MEMO_FIELD)...as I looped through the

recordset I tested to see if LEN(MEMO_FIELD) was null or >0...if so run
a 
query that appends just that record to my new table...when it got to a

corrupt record...the LEN function caused an error...and error handling

simply sent it to the next record.  After, I compared case numbers from
the 
original to the new table to display my corrupt records.

Just thought I'd share...hope it helps someone.

Thanks,

Mark A. Matte

P.S...Also, all of the objects had user security so I couldn't look at

anything in design anyway, but the app would still let me open the db 
window...thanks to the wealth of knowledge on this list...I opened a
blank 
db, draggedNdropped...voila...no more security.  Just a reminder for
those 
of us still using A97.  Thanks Again...



>From: "Mark A Matte" <markamatte at hotmail.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com 
>Subject: Re: Re: [AccessD] Corrupt records
>Date: Wed, 04 May 2005 21:00:05 +0000
>
>Annie,
>
>This db has been removed from the network and resides on my local
machine.  
>Just a note I did NOT build this one...when they first showed it to
me...I 
>warned that it was poorly written and this would eventually happen. 
I'm 
>kinda the UN-official last resort to get back into it.  I think my
looping 
>strategy might work...but I keep running into walls after about 20k 
>records...I'll share the end results if anyone's interested in the
results.
>
>Thanks,
>
>Mark
>
>>From: <accma at sympatico.ca>
>>Reply-To: Access Developers discussion and problem 
>>solving<accessd at databaseadvisors.com>
>>To: Access Developers discussion and 
>>problemsolving	<accessd at databaseadvisors.com>
>>Subject: Re: Re: [AccessD] Currupt records
>>Date: Wed, 4 May 2005 16:47:51 -0400
>>
>>Mark,
>>
>>Have you tried to add your record to another table using a query? 
Also, 
>>is your data on a server or shared computer?  You might want to try
to 
>>closed up all computer and restart only the one with the data and
then try 
>>again a repair and compact.  I've found that with A97, closing every

>>computer can solve a few problems.
>>
>>Annie
>>
>> >
>> > De: "Mark A Matte" <markamatte at hotmail.com>
>> > Date: 2005/05/04 mer. PM 04:32:08 GMT-04:00
>> > À: accessd at databaseadvisors.com 
>> > Objet: Re: [AccessD] Currupt records
>> >
>> > Thanks for the feedback,
>> >
>> > I've tried repair and compact...export(bd,excel,csv),import,
copy,
>> > dragAndDrop, delete from table, delete with query, delete field
with code.
>> >
>> > Now I'm trying to loop though each record...if its good...append
to another
>> > table...if bad(if the code catches it) skip it...already had to
tweak the
>> > code a few times...but I think I have it.
>> >
>> > Anyone have any ideas in case though?
>> >
>> > Thanks,
>> >
>> > Mark
>> >
>> > >From: <accma at sympatico.ca>
>> > >Reply-To: Access Developers discussion and problem
>> > >solving<accessd at databaseadvisors.com>
>> > >To: Access Developers discussion and
>> > >problemsolving	<accessd at databaseadvisors.com>
>> > >Subject: Re: [AccessD] Currupt records
>> > >Date: Wed, 4 May 2005 16:23:34 -0400
>> > >
>> > >Hi Mark,
>> > >
>> > >Did you try a repair and a compact?  I did get some #Error in A97
db and
>> > >the repair and compact always did solve it!
>> > >
>> > >
>> > >
>> > >Annie
>> > > >
>> > > > De: "Mark A Matte" <markamatte at hotmail.com>
>> > > > Date: 2005/05/04 mer. PM 03:36:01 GMT-04:00
>> > > > À: accessd at databaseadvisors.com 
>> > > > Objet: [AccessD] Currupt records
>> > > >
>> > > >
>> > > > Hello All,
>> > > >
>> > > > I have an A97 db with some corrupt records...there are memo
fields reading
>> > > > #Error...when I try to copy, delete, or edit this thing its
says Jet stopped
>> > > > because me and another user are trying to change the same data
at the same
>> > > > time...
>> > > >
>> > > > I just need to get rid of this record.
>> > > >
>> > > > Any Suggestions?
>> > > >
>> > > > Thanks,
>> > > >
>> > > > Mark A. Matte