Avatar of Davisro
DavisroFlag for United States of America

asked on 

Access Performance Now Terrible on my Local Machine

Experts,

I have a departmental Access Db on a Windows Server on our network and I put DEV copies on my local machine because its faster to navigate. I recently had a Windows update on my local machine to version 2004 that failed and reverted back to version 1809. About the same time, my Access performance on my local machine slowed down remarkably. So for example, I just did a test to open a 1.7mil record table on the Windows Server version and it took 15 sec. On my desktop, to open the same table took 70 sec!
It used to be faster on my local machine than on windows server. Is this performance issue due to the failed windows update?

Thanks
Windows 10Microsoft AccessWindows Server 2008

Avatar of undefined
Last Comment
Davisro
Avatar of Robert
Robert
Flag of United States of America image

Are you opening a copy of the same file? If not try copying a fresh version of it down to your PC and testing again.
If it is a different version of the file try a compact/repair on the DB and see if that helps.
As for the update it is possible it changed something but typically when updates fail and roll back it replaces all the files it modified.
If the files are the same version I would try a reinstall of Access. (or the runtime which ever your using)

It's hard to say, but I would first ensure that your DB is pointing to the right datastore (your local drive and not the server).

Use the Linked Table Manager to check that or check a table from the debug window (Ctrl/G) with:

?  CurrentDB().tabledefs("mytable").Connect

and hit return.  The connect string will show you where that table is pointed to.

Jim.
Avatar of Davisro
Davisro
Flag of United States of America image

ASKER

It a split database and i copy both the front and the back end of the Prod version to my hard drive and then I always relink the Front end to the local copy of the back end.
The table that I'm testing is in the back end and im opening it from the front end. just for kicks I went into the back end and it opened almost immediately
Get this...then i tried to open a different large table, about 1.8mil records, but this one is in the front end and it also took about one minute to open...so somehow my front end is slow but its not related to linked tables.
I've never seen Access behave this way before so i dont know what to make of it
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Davisro
Davisro
Flag of United States of America image

ASKER

yep i have an i7 8th Gen laptop, about 1 year old
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo