locked
"Out of Memory" error 7 RRS feed

Answers

  • hello,

    That's often cause by bad application design, which ends up in memory leaking, so first check your code if you close & destroy all unneeded objects.

    SQL Server itself won't cause such errors.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by nitraw26 Thursday, November 10, 2016 4:10 AM
    Wednesday, October 19, 2016 4:18 PM

All replies

  • hello,

    That's often cause by bad application design, which ends up in memory leaking, so first check your code if you close & destroy all unneeded objects.

    SQL Server itself won't cause such errors.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by nitraw26 Thursday, November 10, 2016 4:10 AM
    Wednesday, October 19, 2016 4:18 PM
  • Hi nitraw26,

    Could you show more things about your issue? Could you share the code to clarify how do you update large amount of data by VBA program? What data do you want to update?

    You should also make sure the VBA code is right and then physical memory is enough. If the data is too large, you could consider splitting them into smaller pieces to avoid error.

    Best Regards,

    Albert Zhang

    Thursday, October 20, 2016 6:12 AM