Jet and Batch Updates

From: Jared (Jared_at_discussions.microsoft.com)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 09:05:02 -0800

I'm trying to use batch updating on a Jet database.
I'm able to open a recordset with locktype=adlockbatchoptimistic.
However, when I get to my second "AddNew" statement, I get an error message
stating that the "Number of rows pending changes exceeds the limit".
Does Jet support batch updating?

Relevant Pages

  • Re: Need help with a DAO to ADO conversion
    ... and loop through the Fields collection of the ... resultant recordset, looking at the names of each field. ... Doug Steele, Microsoft Access MVP ... If the BE's a Jet database, then it's not ODBC: ...
    (microsoft.public.access.formscoding)
  • Re: Need help with a DAO to ADO conversion
    ... One way of checking using strictly SQL would be to open a recordset using ... Doug Steele, Microsoft Access MVP ... If the BE's a Jet database, then it's not ODBC: ...
    (microsoft.public.access.formscoding)
  • Re: Jet and Batch Updates
    ... > I'm trying to use batch updating on a Jet database. ... > I'm able to open a recordset with locktype=adlockbatchoptimistic. ... Dim con As ADODB.Connection ... rs.Requery 'Requery data from source ...
    (microsoft.public.data.ado)
  • Re: How to use ADO Seek Method With Multiple Columns
    ... I've got a small table in a jet database with three fields (rpt_pd, ... compound index named "Reporting_Period" which is comprised of both ... WHERE clause to your recordset source, you might not have much choice, eg. ...
    (microsoft.public.data.ado)
  • Re: Filecopy and Database manipulation
    ... > 2- Delete several row in myDB located at strSourcePath and close MyDB ... > recordset through the DataEnvironment variable. ... > Then the third step doesn't complete with success, the filecopy return ... DAO since this is a Jet database)? ...
    (microsoft.public.vb.general.discussion)