I have a MS Access 2010 front-end containing linked tables from an SQL Server 2008 database. Performing INSERTS on one of the linked tables is horrendously slow despite the fact that I'm adding just one or two records to the linked table from a local table. Note that I'm using the DoCmd.RunSQL method to issue the INSERT statement and the users aren't getting any server errors -- just a never-ending hourglass.
The target linked table only contains <2000 records, although it does get a lot of transactions as I have about 20 users routinely SELECTING, UPDATING, and INSERTING on the linked table.
Is there something inherently wrong I'm doing that is causing this INSERT to run so slow?