RE: How do I avoid 80040E21 error from AddNew after failed Update?
- From: wrighj <wrighj@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 10 Mar 2008 18:30:00 -0700
"wrighj" wrote:
I am using the ADO 2.5 library, Access 2003 and VBA. After receiving and
handling a 80040E21 (dup key) error from an Update method, I receive this
same error from the AnnNew (no fields/data parameters provided) method.
I just answered my own question. By performing a CancelUpdate in the err
handling, the Recrodset is reset allowing the sebsequent methods (e.g.,
AddNew) to execute without error.
.
- Prev by Date: Re: OleDbCommandBuilder insert query will not work? dataset to Access
- Next by Date: Re: Enum redefinition when upgrading to VS2008
- Previous by thread: Re: OleDbCommandBuilder insert query will not work? dataset to Access
- Next by thread: Re: Enum redefinition when upgrading to VS2008
- Index(es):
