Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Star Lounger
    Join Date
    Jan 2010
    Location
    Graeagle, California, USA
    Posts
    82
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Strange delay launching Access mdb and/or mde applications

    I have several Access applications that "normally" launch in the "blink-of-an-eye". Yet, there are days when it takes 10 seconds before the app appears on my screen. Then, adding to the mystery, the day comes where the delay will disappear as suddenly as it first appeared. I've determined that size and/or whether the app is split has nothing to do with the delay. All components are stored on the "C" SSD. Access by itself launches normally without delay.

    My Win 10 Pro system has not yet updated to the "anniversary" release.

    Any ideas as to what might be causing the issue.

  2. #2
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,572
    Thanks
    5
    Thanked 1,057 Times in 926 Posts
    What are you machine hardware specs? Could be that Access is still cached in RAM.
    Joe

  3. #3
    Star Lounger
    Join Date
    Jan 2010
    Location
    Graeagle, California, USA
    Posts
    82
    Thanks
    2
    Thanked 0 Times in 0 Posts
    See screenshot below for specs.

    A couple of observations:
    1) If I open the mdb file directly from Windows explorer there is no delay.
    2) Likewise, if I first open Access and then select the mdb directly from recent files there is no delay.
    3) It is ONLY if a launch from a desktop shortcut OR a Start menu icon is there a delay.

    How could I determine if Access is using RAM as its cache?

    From Belarc:

    000.jpg

  4. #4
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,572
    Thanks
    5
    Thanked 1,057 Times in 926 Posts
    Windows will automatically keep programs in memory until the RAM is needed by something else. According to Belarc, you have 8 GB of RAM. If you use the same programs regularly you have enough RAM that Access will remain in memory for quite a while after you close it.
    Joe

  5. #5
    Star Lounger
    Join Date
    Jan 2010
    Location
    Graeagle, California, USA
    Posts
    82
    Thanks
    2
    Thanked 0 Times in 0 Posts
    OH TERRIFIC!!!! I didn't check before my post a few minutes ago, but now mdb's and mde's launch instantly, either from a Start icon OR desktop.

    There were NO Win 10 updates or a re-boot during the night.

    I have no clue as to the strange behavior.

    Bill

  6. #6
    Star Lounger
    Join Date
    Jan 2010
    Location
    Graeagle, California, USA
    Posts
    82
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I'll look at RAM usage the NEXT time the delay occurs, though I doubt that storage is the issue unless there are un-detected hardware problems. BTW, I did try a re-boot but that didn't clear up the delay issue.

    Anything else I could look at that would give a clue?

    Bill

  7. #7
    Star Lounger
    Join Date
    Mar 2015
    Location
    Rhode Island
    Posts
    67
    Thanks
    1
    Thanked 6 Times in 4 Posts
    Bill: Check Event Viewer when this happens. My system was clean-installed and I've had nothing but bizarre permission problems with DCOM that I've had to manually fix thanks to tips I've found on Microsoft's and other sites. From time to time, I'll get an error that a particular CLSID & APPID isn't permitted to my user-ID to start an application...but it starts anyway...after a delay. I'd love to know what's causing this.

  8. #8
    Star Lounger
    Join Date
    Jan 2010
    Location
    Graeagle, California, USA
    Posts
    82
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I'm not totally familiar with the Event Viewer in Win 10, but I found the APPID and there didn't seem to be any problems there. I could find no reference to CLSID at all.

    My delay problem persists.

    Bill

  9. #9
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,572
    Thanks
    5
    Thanked 1,057 Times in 926 Posts
    I am not saying RAM is the problem. It could be why sometimes you don't see the problem. It would not surprise me that you see the issue after a re-boot. That is when there is nothing related to Access loaded. When you go to run Access the first time after a boot is when it will take the longest to load. Access plus any common Office modules plus your database must be loaded. Once Access is loaded and you then close Access some/most of it will remain in memory until Windows decides to completely unload it. If you restart Access when part is still in RAM it will start much faster. NOTE: you can not easily tell if part of Access is still in RAM as the RAM is available for use but Windows just keeps track of what is there in case it can be reused.
    Joe

  10. #10
    Star Lounger
    Join Date
    Jan 2010
    Location
    Graeagle, California, USA
    Posts
    82
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I understand paging completely and the sometimes troubling performance that stems from systems that don't have enough memory to adequately support the systems nominal use. In the "old days", mainframe systems starved for memory could get into what is called "page thrashing" where all of the system resources were busy servicing page faults............. we've come a long ways.

    Anyway, I think to some extent that I misunderstood your first post. With my mindset more focused on the general facilities of my PC and its inherent speed, even after a reboot and the initial loading of Access and the designated DB, there's "normally" little or no appreciable delay with a 1st launch.

    So, last night before I quit for the night, the delays for my Access apps were pervasive, like 10 to 12 seconds. As I awoke my system this morning all the delay issues have disappeared. No system updates or reboots were done during the night. The only activity scheduled during the night is the Acronis backup and a scheduled task that copies a couple of files from NAS to a portable hard-drive.

    If I gain any insight as to what might be astray here I'll post again............. SIGH!

    Bill

  11. #11
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,572
    Thanks
    5
    Thanked 1,057 Times in 926 Posts
    Have you run Task Manager to see if there is anything else taking over?
    Joe

  12. #12
    Star Lounger
    Join Date
    Jan 2010
    Location
    Graeagle, California, USA
    Posts
    82
    Thanks
    2
    Thanked 0 Times in 0 Posts
    No, but that's a good idea. The next time my system gets into "its delay state" I'll look at processes to see if anything in the system is chewing up resources.

  13. #13
    Star Lounger
    Join Date
    Jan 2010
    Location
    Graeagle, California, USA
    Posts
    82
    Thanks
    2
    Thanked 0 Times in 0 Posts
    000.jpgDelays have returned. I captured the performance tab from the Task Manager as I awaited the completion of the launch. There's no indication that another task or service is grabbing needed resources. (See screenshot)

    I remain clueless,
    Bill

  14. #14
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,572
    Thanks
    5
    Thanked 1,057 Times in 926 Posts
    I think I neglected to ask which version of Access and is it up-to-date with patches?
    Joe

  15. #15
    Star Lounger
    Join Date
    Jan 2010
    Location
    Graeagle, California, USA
    Posts
    82
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Sorry, I normally would have provide those details un-solicited.

    My Win 10 Pro is still on 1511. Office 2003 with all of the available security updates are complete, as far as I"m aware.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •