Is there a faster and better way? (1 Viewer)

I am redesigning an Access front-end SQL Server back-end for a client and I am pulling out of a SQL Server table information on employer monthly contributions for an employee medical spending account. A set of records is appended to an Access table for viewing and editing. In Access I have created an Update Query that will then update all of the records in SQL Server from the Access table.

This seems to work fine in when I test it, but is there a way to do this with ADO and avoid having to use an ODBC linked data table, or is there a way to use the linked ODBC data table but use a DAO method for faster update?

Thanks in advance for any ideas