[AccessD] Currupt records

Mark,
I recently had a corrupted mdb. I found quite a few companies selling or
providing data recovery services. In my case none of them worked but its
definitely worth a try googling up a few and trying them out. Many have no
charge for reporting what they can recover or a short trial period.

Recent threads have proven how poorly I google so I'll leave that to you :o)

John B.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Wednesday, May 04, 2005 3:32 PM
To: accessd at databaseadvisors.com
Subject: 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
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com