Morning all
I've recently upsized my test Access db and are currently learning of various ways of making it running faster.
I have got a number of scenarios where I add new records to various tables in VBA by using AddNew with DAO Recordset.
My understanding is that currently, when I open a recordset, all data from a specific table is transferred to the Front End database and then the new data row is added. Therefore, I am wondering what best practice is - whether it's an INSERT query or a different way of using the Recordset?
I've recently upsized my test Access db and are currently learning of various ways of making it running faster.
I have got a number of scenarios where I add new records to various tables in VBA by using AddNew with DAO Recordset.
My understanding is that currently, when I open a recordset, all data from a specific table is transferred to the Front End database and then the new data row is added. Therefore, I am wondering what best practice is - whether it's an INSERT query or a different way of using the Recordset?