[AccessD] SetWarnings False

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