[AccessD] append query error count

I doubt if you can Lyle. I think you'd have to run select queries either
before or after the append to report data problems.

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-admin at databaseadvisors.com 
> [mailto:accessd-admin at databaseadvisors.com] On Behalf Of 
> lyle.hannum at co.wake.nc.us
> Sent: 27 February 2003 20:43
> To: accessd at databaseadvisors.com
> Subject: [AccessD] append query error count
> 
> 
> Hi
> 
> When running a append query you may occasionally generate a 
> Access msgbox similar to: "Microsoft cant append all the 
> records in the append query. Microsoft set 17 field(s) to 
> null due to a type conversion failure..." Does anyone know 
> how to capture the number and type of append failures? TIA
> 
> Lyle Hannum
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
>