Significant slowdown with Docmd.RunSQL "INSERT INTO .."

%3CLINGO-SUB%20id%3D%22lingo-sub-1394046%22%20slang%3D%22en-US%22%3ESignificant%20slowdown%20with%20Docmd.RunSQL%20%22INSERT%20INTO%20..%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1394046%22%20slang%3D%22en-US%22%3E%3CP%3EWith%20office%20update%2012624.20382%20I%20have%20noticed%20significant%20(10X)%20slow%20down%20in%20MS%20Access%20when%26nbsp%3BI%20use%26nbsp%3B%3C%2FP%3E%3CP%3EDocmd.RunSQL%20%22INSERT%20INTO%20..%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBefore%20the%20update%201500%20records%20were%20inserted%20in%202%20seconds%2C%20after%20update%2025%20seconds.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20normal%20speed%20I%20had%20to%20roll%20back%20the%20office%20version%20plus%20made%20a%20system%20restore%20on%20the%20restore%20point%20before%20update.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20issue%20is%20with%20365%2C%202016%20and%202019%2C%20and%20with%20inserting%20into%20local%20tables%20or%20linked%20tables%2C%20it%20doesn%E2%80%99t%20mater.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20suggestions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1394046%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Visitor

With office update 12624.20382 I have noticed significant (10X) slow down in MS Access when I use 

Docmd.RunSQL "INSERT INTO .."

 

Before the update 1500 records were inserted in 2 seconds, after update 25 seconds.

 

For normal speed I had to roll back the office version plus made a system restore on the restore point before update. 

 

The issue is with 365, 2016 and 2019, and with inserting into local tables or linked tables, it doesn’t mater.

 

Thanks for any suggestions.

0 Replies