Re: BatchUpdate with ADO

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Look at the UpdateBatch method of the ADO recordset object.

--
Terry Kreft
MVP Microsoft Access


<adoMain@.> wrote in message
news:upfaf1t5s4ji3ccub3gupi8au44k1v4gu0@xxxxxxxxxx
> I have a VB module that creates a lot of records in a disconnected
> recordset object. All the fields in the recordset are identical to
> the field names in an Access 2000 .mdb file table.
>
> The table in the .mdb file will always be completely EMPTY of all
> records before any code operates on it.
>
> I thought there might be a way of just .batchupdate(ing) my
> disconnected recordset into the table in the .mdb file ... ??!!??
>
> Must I loop and .update with ADO?
>
> I need to get this done pretty quickly ... I want it to be the most
> elegant solution.


.

Relevant Pages

  • Re: ADO->Jet, seek method EOF, all subsequent setting the index fa
    ... 10,000 lookups using command method: ... table direct recordset into my important table, ... > I would setup a Command object with an-adhoc SQL query on the PK and Record ... > parameters and close the Recordset object when finished. ...
    (microsoft.public.data.ado)
  • Re: ADO->Jet, seek method EOF, all subsequent setting the index fa
    ... 10,000 lookups using command method: ... table direct recordset into my important table, ... > I would setup a Command object with an-adhoc SQL query on the PK and Record ... > parameters and close the Recordset object when finished. ...
    (microsoft.public.data.ado)
  • Re: File and Folder Listing.
    ... >Dim strPath 'Path of directory to show ... >' A recordset object variable and some selected constants from adovbs.inc. ... >' In order to be able to sort them easily and still close the FSO relatively ...
    (microsoft.public.inetserver.asp.general)
  • Re: Run time error 3421
    ... I believe the problem is that your OpenRecordset statement is incorrect. ... recordset is an object variable that represents the Recordset object you ... > Set rstRecords = dbsDatabase.OpenRecordset("SELECT Max ...
    (microsoft.public.access.formscoding)
  • Q. Problems with combo box NotInList event
    ... Private Sub Combo133_NotInList ... 'connection and recordset object variables ... 'Dim cn As ADODB.Connection ...
    (microsoft.public.access.formscoding)