[AccessD] Append Query Problems

Thanks to Gustav and Don.  Gustav, I used your suggestion - I had about
88,000 records to append.  It didn't take too long to find the bad record.
Thanks again.

Tim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: Saturday, August 02, 2003 3:30 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Append Query Problems


Hi Tim

> I am using A97.  I need to append the records from one table to another
> identical in structure.  The query gets about half way done and then stops
> with the following error message:  "You tried to assign the Null value to
a
> variable that isn't a Varient data type."  I am assuming that there is
> corruption in one of the records.  How do I go about finding that record?

Do a binary approximation ... append half of the records. If it has no
errors, append the other half - this should fail.
Now, follow this route by appending half of the failing recordset and
so on - eventually you'll have tracked down the failing record.

/gustav

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