I have a Access 2003 app that allows the user to work with SQL Server data in a datasheet view. The SQL table is linked to the Access db. When the user tries to edit/update a cell in the datasheet it is very slow the first time the table is edited. After that the updates/edits are immediate.
Any ideas??
The SQL table contains > 2,000,000 recs.