Data Entry Unbound Form (1 Viewer)

[KeithG]

I am creating an ubound form for data entry in the FE of my db. Once the user enters the data and presses the update button the form needs to add records to upto 8 tables. Is it more efficent to open up a recordset and use the add new method. Or use docmd.openquery to open an Append query to append the info? The table contain around 20,000 records so I assume that run the Append query would be more efficent than opening up a recordset for each new record.

 

[edtab]

It is my experience that running queries work faster than opening recordsets then adding new records via VBA (rs.addnew).

Even running an sql statement via the DoCmd.RunSQL command works faster than adding records via recordsets.

 

[boblarson]

Keith:

I think I'd tend to agree. If you can create a set of append queries, it would likely be faster than processing via a recordset opening up 8 different tables.