Previously, our app used the default "Update Resync" value
("adResyncAutoIncrement") to get back newly generated identity field
values. Then we changed our app to use "adResyncAll", which worked
fine.
Now, we want to go back to using "adResyncAutoIncrement", but the
recordset won't stop returning ALL the updated values. We've tried
setting "Update Resync" to "adResyncAutoIncrement" and "adResyncNone"
to no avail.
The reason we only want the identity values resync-ed is because we
have added audit trail code after our UpdateBatch call. We ** DO **
want the new ID values for the audit trail, but we also want to retain
the recordset's OriginalValues for differencing.
Does anyone know why we can't STOP our recordset from resyncing?
Re: Access 2007 - Anyone having trouble with really large conversions? ... I have a fairly large app,... program, which has added even more forms, queries and linked tables. ... get errors when opening a recordset for a linked table. ... So Access 2007 always seems to use Recordset2 objects for its forms and reports... (comp.databases.ms-access)
Re: Datareader, dataset, else? ... A DataReader is most closely analogous to a Read-Only/Forward-Only Recordset... > I'm writing my first real asp.net app at my job, ... > seems like I have to choose between using a SQldatareader or a dataset. ... (microsoft.public.dotnet.framework.aspnet)
Re: Resync or Requiry ... The recordset returns a SINGLE row only ...Resync - The original SELECT has been taken apart and a SELECT is being ... returns a single row, a requery is better than a Resync. ...Requery method updates the data in a Recordset ... (microsoft.public.data.ado)
Re: Application crashes with "On Error Resume Next" ... The code is intended to move data from one recordset to another - ... however the "ChangedCarveOuts" recordset is built using a stored proc ... Next is then to allow the app to skip any potential 3065 (Item cannot ... ran the app on a machine at the client site that uses MDAC ... (microsoft.public.vb.bugs)
