locked
Long refresh when VBA editor in Access is active RRS feed

  • Question

  • I have tried to search the forum for an answer on this question, but failed. So here is my question:

    As soon as I open the VBA editor in Access 2019 access starts to update (refresh) it self more and more often and it takes longer and longer time. After (maybe an hour) it is only possible to write 5-10 characters (!) before an refresh sequence starts and I have to wait for a long time (30 seconds) before I can write my next 5-10 characters. The only way to make the situation better again is to close Access and restart the computer. Then the refresh times starts with a longer time intervall again (but after an hour the same again). Only closing Access and opening it again does not improve the situation. This bad behavior started during this fall before that everything was okay. It seems like Access is storing a copy somewhere and desperat  trying to update the copy. 

    Anyone who recognize this behaviour and know how to fix it?

    Tuesday, December 17, 2019 2:23 PM

All replies

  • Is it possible that you have a cloud backup like OneDrive or Google Drive that constantly checks if the backup file is the latest copy?


    Bill Mosca
    https://wrmosca.wordpress.com/
    https://groups.io/g/MSAccessProfessionals

    Tuesday, December 17, 2019 3:12 PM
  • Does this happen with just one database or all databases?

    Have you tried performing an Office/Access Repair?
    What is your Access build no?  Are you up-to-date?
       Have you tried updating or reverting to another build to see if that helps?

    Are you working with local files and not LAN/WAN files (server, OneDrive, DropBox, GoogleDrive, ...)?


    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Tuesday, December 17, 2019 6:25 PM
  • Hi, I have One Drive but the Access .accdb is not in the OneDrive folder. However, this is what I suspect but can't find any evidence that this is the case. 

    Jan Holm

    Thursday, December 19, 2019 4:21 PM
  • I will try your proposals and see if it improves the situation. Since it is Office 365 Access I believe I have the latest version.

    I am working with local files.

    Thursday, December 19, 2019 4:23 PM
  • Do you have a form timer event running in the background?

    If so try disabling it, at least temporarily, and see if that solves the problem

    Thursday, December 19, 2019 8:53 PM
  • Try turning off the sync utility for OneDrive to see if that makes a difference. If it does, it should mean that the file is being backed up.

    Bill Mosca

    https://groups.io/g/MSAccessProfessionals

    Friday, December 20, 2019 7:16 PM
  • Hi, I have no timer in the background.
    Saturday, December 21, 2019 12:08 PM
  • Hi, I turned of the sync for OneDrive but there was no change. 


    Saturday, December 21, 2019 12:10 PM