[AccessD] Speed Issues on network just with Access App

Mon Nov 7 10:02:19 CST 2016

Hi Gustav, thanks for response.  I'm thinking it is something with a Windows Update that happened sometime in early July, which coincidentally was when I started rolling out the 3040 upgrades.  Received call this morning that someone's pc is really dog slow (only in the Access program) and I have already switched him out from a 3040 to an Opti 7010 w/SSD drive (another user has one of these w/o issue).  They are going to switch him back to his old XP machine to see what happens.

Reason I'm leaning more towards a windows update is that the 3020's w/Win7 I had in play for some time now had not shown any issues, but recently, they too are having trouble.  But the frustrating part is that not everyone experiences the problems.  And if they do, it is a here and there problem for part of a day and then nothing wrong for a good stretch.

That said, I feel if I were to put in a Win 10 box, I still wouldn't have the warm and fuzzies if it worked for a while.  Maybe the second one introduced would all of a sudden exhibit the problem.  I wish it was something I could repeat on demand so I'd know where to look (like a bad reference to a dll or ocx.)

As to running 15 folks in A2K, I had an A2K insurance app that was as sophisticated or more so than this one, running with 60+ users in three locations w/o issue.  Company was bought out a little while back so they no longer use it, but no real issues to speak of.  Leary of 2016 since I do use some third party stuff that I'd have to trace out and try to develop replacement code or workarounds.  Certainly possible, just not a quick easy gig.  Something that would eventually need to be done, for sure...  SQLServer backend sounds like where this should go.

Thanks,

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: Monday, November 7, 2016 3:05 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Speed Issues on network just with Access App

Hi John

It would be interesting if you could have the option to fire up a 3040 with a clean Windows 10 install, not an update from Windows 7, and check that out. I have nothing but good experiences with Windows 10.

Also, I must say running a 15-user application in Access 2000 is a bit, eh, exotic. Indeed as you can do a straight upsize to Access 2016 just by opening the mdb and run a convert to the accdb format. The changes needed will be minor if you have no fancy coding.

Not a direct answer to your question, I know, just some thoughts.

/gustav

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

Darryl/Jim, thanks for replies and suggestions.  Here's the reason I believe the problem is with the jet engine on the local pc's OR a Windows Update, and not the network.

Everything else runs stellar on the network.  Internet Explorer/Chrome no issues.  VOIP phone system, no problem.  Quickbooks w/6 simultaneous users, no problem.  Opening files over network shares, no problem.  I was hoping I'd have the slow network performance on word/excel files over the network as I have seen that multiple times and have been able to change settings on the server to correct.  Unfortunately, works just fine.  All Windows 7 Pro 64 bit with a few older XP boxes which have never and still never experience the speed problem.

I eliminated the new gig switch I put in a little while back by getting an older model that is much less sophisticated, and no issues w/anything except the random slowdowns with Access.  That goes for both the new and the older switch so I have to rule that out.  And rule out the wiring as I have moved workstations around to see if maybe a bad cable was in play, but problem still randomly happens on original location and moved location.

The server does not have Access installed, just has the MDB's on a shared drive.  Copy of FE on local PC's C drive.  I have some C drives that are SSD's, but doesn't seem to matter.

What the norm has been for the 20+ years this A2K system has been around is that if you are the only one in (say on a Saturday), everything is lightning fast.  Screens open in a second or less.  When 2 or more people get in, then the screens slow a bit, but usually no more than 2 seconds to open any form, very acceptable.  No complaints, even when 15+ are in at the same time, some running multiple instances of Access (one instance runs a Dispatch Board on one monitor, the other instances runs the rest of the program, like Work Order Entry, Purchase Orders, Quotes, etc.)  The other thing I always do before putting an update into the FE is to create a blank MDB and import all the objects from the FE I'm working on and compile the FE.  This is what they run, a clean FE. There was phenomenon back on their server in Windows NT days where if I made a change to a report or form say on one machine, which would decompile that FE, if a second person connected to the app, they would no!
 tice a 2 - 3 minute delay in opening any form, every time they clicked on a button or other form.  As soon as everyone got out, one person was left, that person would experience very fast performance again.  Creating blank mdb and importing all objects and compiling took care of this, so I keep doing this slightly pain in the tail procedure whenever making updates to the system.

Finishing up, not too many months ago the speed issue creeped in.  It was around the time of both the addition of the new switch and introduction of Dell 3040 Optiplex Micro machines.  I have addressed removing network switch, but that didn't help.  I can't remove all of the 3040's because of problem with old XP boxes and the version of QB people are running.  There are maybe 4 or 5 3040's in play.  Quite possible a Windows Update came across which would only effect the Win7 boxes, that's a high possibility in my book.

And not being able to explain this one, I've seen a person being the only one in the system on a Saturday morning and the system hung for minutes at a time (white screen) just opening the Access App.  Not even the typical places which are several of the forms/procedures.  That had never happened ever, so a gremlin has snuck in somewhere and I just do not know where.  I do not know what tool(s) to utilize that may help determine the hangup (maybe something like Wireshark, I do not know.)

Thanks for listening.

John

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