Hey everyone,
I'm a sysadmin and I recently joined a user's PC to the domain. Initially, this helped her resolve some issues she was having, but then she reported that her MS Access and a proprietary program relying on it are now significantly slower. Tasks that used to take about an hour now stretch to 2 or 3 hours! I haven't changed anything else, and I've tried several fixes, like checking for updates, rolling back Office 365 apps, cleaning up the disk, and rebooting multiple times. No luck so far. Her setup is a Dell OptiPlex 7000 with a Core i7-12700, 32GB RAM, and an NVME SSD, running Windows 11 Pro 24H2. Any insights or suggestions would be greatly appreciated!
5 Answers
User profiles can cause slowdowns too, especially if you’ve got profile redirection enabled. If the databases were previously on her local machine and have now been moved, that could be the problem.
Have you considered migrating the Access data to SQL and using an ODBC connector? It can really speed things up, and Access can still function as the front-end, so you keep the familiar interface while boosting performance.
Have you tried moving her computer account to an Organizational Unit (OU) with no GPOs and running a gpupdate /force? This can help determine if GPOs are the culprits. Additionally, testing the program on a non-domain machine can help identify if it’s a domain-related issue.
Since you connected her machine to the domain, it’s worth checking if any Group Policies (GPOs) might be causing the slowdown. Try looking in the Event Viewer for logs that could indicate issues. Also, see if she's using a VPN or VDI—those can impact performance too! You could also test the app on another device to see if the slowdown persists.
Check where the MS Access database and the program are installed. If they’re on OneDrive or another remote location, that might slow things down significantly. Local installations generally perform better.
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures