Forum Discussion

JAZ_OV's avatar
JAZ_OV
Copper Contributor
Jul 13, 2022

Windows or Office 365 Updates on 7/12/22 Introduced Error with TransferText in vba for Access

After the above noted updates I have received several reports of Access error 3125.  I have traced this issue to a saved import specification.  Below is an example of the error when using an import s...
access
office 365
arnel_gp's avatar
arnel_gp
Iron Contributor
Jul 19, 2022
it is much faster if you just Open a Recordset and Append record to it than using Insert Query.
JAZ_OV's avatar
JAZ_OV
Copper Contributor
Jul 21, 2022
Reading from an external text file - the data is not yet in Access.
  • arnel_gp's avatar
    arnel_gp
    Iron Contributor
    Jul 21, 2022
    in my experience, it is much faster to .Addnew to a recordset, multiple times than executing "Insert" query multiple times.
    • JAZ_OV's avatar
      JAZ_OV
      Copper Contributor
      Jul 22, 2022
      Never thought of that, thanks for the tip!

Resources