I will not discuss what is faster, open a recordset or use a SQl-Command insert.
But when you will use a recordset for AddNew, you can open your table with
myRecordSet.Open "Select * from myTable where 1 = 0", .....
For ADO now all necessary informations are given for the recordset...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.