[AccessD] Speed Issues on network just with Access App

[Gustav Brock]

Hi John

That should work, but don't forget to map drives from within the VM. Don't use internally carried-over drives from the host.

Still, I regard this as a dead end, for emergency use only.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af John Bodin
Sendt: 8. november 2016 15:52
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Speed Issues on network just with Access App

Hmmm, great find Gustav.


I wonder if my system worked fine when I only had a few Win7 boxes in play and mostly XP boxes, but now that the majority are Win7, this magnifies the issue and brings it to light.  Ug!


Just had a thought.  If I can confirm that the re-introduction of an XP box yesterday to a user who was having tons of lag issues with two different Win7 boxes, worked w/o issue yesterday and so far today, my thought would be to install XP Mode on the Win7 Computers, install Access and run the app that way.  I'd have to do a few other installs as well (like PDF995, Chrome which will be limited in how it works, etc.) that I'd have to do in the XP vm, but I think that would work.  What do you think?


Thanks again.   Appreciate it.


John


John Bodin

sBOR Office Systems

jbodin at sbor.com<mailto:jbodin at sbor.com>

________________________________
From: AccessD <accessd-bounces at databaseadvisors.com> on behalf of Gustav Brock <gustav at cactus.dk>
Sent: Tuesday, November 8, 2016 7:40 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Speed Issues on network just with Access App

Hi John

At Wikipedia:

    https://en.wikipedia.org/wiki/Microsoft_Access

I noticed this:

<quote>
In July 2011, Microsoft acknowledged an intermittent query performance problem with all versions of Access and Windows 7 and Windows Server 2008 R2 due to the nature of resource management being vastly different in newer operating systems.[35] This issue severely affects query performance on both Access 2003 and earlier with the Jet Database Engine code, as well as Access 2007 and later with the Access Database Engine (ACE).[35] Microsoft has issued hotfixes KB2553029 for Access 2007 and KB2553116 for Access 2010, but will not fix the issue with Jet 4.0 as it is out of mainstream support.[35] </quote>

The reference 35 is here:

    http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/86e59bc0-3524-45be-89d0-3528cfea842b

If that is so (the last sentence), it may be the full explanation for your trouble - and you seem to be hosed.

/gustav


-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Gustav Brock
Sendt: 7. november 2016 17:44
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Speed Issues on network just with Access App

Hi John and Darryl

In my experience, Windows Update has been vastly improved from Win7 to Win8.x and indeed to Win10.
It now runs smoothly in the background.

Also, it can be adjusted to your liking in the Enterprise version; the Home edition is not that flexible.

/gustav