MS Access project with SQL Server - ADO: Smartest way toa add records manually

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

ADO: Smartest way toa add records manually

Atlas

2005-05-27, 7:24 am

Access 2003 (SP1) + .adp project + ADO 2.8 + MS Sql Server 2000

I'm wondering if in a VBA code script it is more efficient & faster adding
records using a cn.execute(--INSERT-STATEMENT) or if it is better to open a
connection and then rs.addnew + rs.update, considering that the latter needs
a SELECT statement before issueing the addnew+update (what if millions
records? Need to fecth only a few just to open the recordset).

Comments appreciated

Sponsored Links