[AccessD] append query error count

Susan Harkins harkins at iglou.com
Thu Feb 27 15:42:00 CST 2003


FWIW, you might begin your search with the following culprit -- in my
experience, it's responsible for the majority of these errors: trying to
append null values to fields with a Required property of Yes. The
zero-length property can cause trouble too.

Susan H.


> 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
> >
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>




More information about the AccessD mailing list