[AccessD] SetWarnings False

Thanks Liz,

There are over 100K records...and somewhere around 300 plus records corrupt. 
  The looping through the records was how I was isolating the corrupt 
records...I just didn't want to click a button everytime it found a bad 
record, I was trying to have the error handling bypass these records. If it 
were just one record...that would be easy...the copy paste into a new table. 
  I pretty much have a handle on it...I recovered 99.3% to a new table.  The 
corrupt records are still viewable in the table...so I'm trying to delete 
the good records from the bad table...so the user can review the 'lost' 
records.  Its just a little hard because you can't join, sort, copy, or 
paste records with this table.  I've used a combination of append and update 
queries, single view forms to loop through...(tried a record set in 
VBA...lets not talk about that one...lol).

It would have just saved time If I could have vba handle the error instead 
of clicking.

Thanks Again,

Mark


>From: "Liz Doering" <ldoering at symphonyinfo.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] SetWarnings False
>Date: Mon, 5 Jun 2006 15:33:39 -0500
>
>Mark,
>
>Your goal is to recover data from a table, right?  Not write code that
>will work around a corrupt record?  And you know what record is corrupt?
>
>Using a make table query to copy all the records from your table up to
>that bad one into a new table.  Then append all the records after the
>bad one into the new table.  Then dump all the records from the bad
>table, or even the whole table.  Or copy all the tables but the bad one
>into a new db.
>
>
>Liz
>
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: Monday, June 05, 2006 2:01 PM
>To: accessd at databaseadvisors.com
>Subject: Re: [AccessD] SetWarnings False
>
>Susan,
>
>Can't delete or edit the record...thats why I'm trying to loop around
>it.
>
>Thanks,
>
>Mark
>
>
> >From: "Susan Harkins" <harkinsss at bellsouth.net>
> >Reply-To: Access Developers discussion and problem
> >solving<accessd at databaseadvisors.com>
> >To: "'Access Developers discussion and problem
> >solving'"<accessd at databaseadvisors.com>
> >Subject: Re: [AccessD] SetWarnings False
> >Date: Mon, 5 Jun 2006 14:05:15 -0400
> >
> >Can you delete that particular record and run it without an error?
> >
> >Susan H.
> >
> >Hello All,
> >
> >In A2K I'm looping through some records...I have warnings set to
> >false...and
> >have error handling dealt with, so I thought...but I still get a Visual
> >Basic run time error.  I have on error goto next record...but instead
>it
> >just breaks on the line referencing the current record...doesn't even
>goto
> >the error handling. Any ideas?
> >
> >Oh yeah...the db is corrupt...I'm just trying to recover some record.
>This
> >is probably my problem...just wanted to run by some fresh minds.
> >
> >Thanks,
> >
> >Mark A. Matte
> >
> >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
> >
> >--
> >Internal Virus Database is out-of-date.
> >Checked by AVG Free Edition.
> >Version: 7.1.394 / Virus Database: 268.7.2/349 - Release Date:
>5/26/2006
> >
> >
> >--
> >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