Drew Wutka
DWUTKA at marlow.com
Thu Feb 27 23:53:00 CST 2003
I don't suppose it is dumping the records into a temporary table is it? (A lot of error producing wizards do that, I don't remember if I have ever seen a query do that though....) Drew -----Original Message----- From: lyle.hannum at co.wake.nc.us [mailto:lyle.hannum at co.wake.nc.us] Sent: Thursday, February 27, 2003 2:43 PM 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/accessd Website: http://www.databaseadvisors.com