[AccessD] Speed Issues on network just with Access App

Tue Nov 8 09:19:08 CST 2016

Agreed on the dead end.  I have to propose upgrading to a newer(est) version of Access and ultimately SQL Server on the back end.  But there is testing that would need to be done no matter if we go with any version 2010 and higher on both the FE and BE, never mind SQL Server.  System has been pretty rock solid over the past 15 years, a few corruptions here and there, except for this most recent speed issue.

I did just check with the user who got his XP machine back and he worked just fine all yesterday and so far today.  He's a happy camper even though he went back in time.  This pretty much confirms that XP is really fine so it does give me both options - short-term XP Mode, longer term upgrade to newer Access and eventually SQL Server.  It will also open up the discussion for an existing retail industry solution so I will have to see how that conversation goes.

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 10:08 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Speed Issues on network just with Access App

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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com