[AccessD] Corrupt records

That's what I always do. Try using the ID as the criteria in the query. Add
records where PKID <= what ever the max ID is. if it works, try a higher
range.

i.e. table has 100,000 records

SELECT * FROM your Table WHERE PKID <=50000

IF that works, then try
SELECT * FROM your Table WHERE PKID >50000 AND <=75000

and so on and so on.

Once it fails, try making the range smaller. I have had cases where I had
more than one corrupt record.

HTH

David McAfee

-----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 2:00 PM
To: accessd at databaseadvisors.com
Subject: Re: Re: [AccessD] Corrupt records


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
> > > >
> > > >
> > > > --
> > > > 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
> >
>
>--
>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