Windows 10 + access MDB file shared in windows 2012R2 server access too slow

Question

I have several computers with windows 10 Pro, running applications that access MDB files that are in a network drive in a windows 2012R2 Server.

The programs run very slow.

The same computer computer with Windows XP runs the applications with no problems, same network connection, only change the hard disk to install Windows XP.

The time to run one specific query, can change from 1 second on XP to 365 seconds on Windows 10.

I disabled Intel SpeedStep and Hyperthreadig on the machine bios that is running Windows 10 and the time in that query came to 111 seconds.

I have also detected that having SMB1 ative in some computers the query runs faster.

Can some help me on this?

Answer 1

Hello

Slow access to MDB files on a network drive can be due to various factors. Here are some potential solutions you can try:

Disable SMB1: SMB1 is an outdated protocol that has been replaced by SMB2 and SMB3. Using SMB1 can slow down file transfers and pose security risks. If possible, upgrade your old device to support SMB2 or SMB3.

Optimize Access Database: Microsoft provides several tips for improving the performance of an Access database. These include creating indexes for commonly used fields, turning off Name AutoCorrect, setting the database to compact and repair automatically, and opening the database in exclusive mode.

Optimize Network Performance: Slow network performance can also affect file access speed. You can try optimizing your network settings, such as enabling large MTU in SMB and disabling bandwidth throttling. You can also check for packet loss in the network trace.

Check Storage Speed: File transfer speeds are limited by storage speed. You can test your storage speed to see if it’s causing the slow file access.

Use Robocopy: Robocopy is a file copy utility built into Windows that can improve file transfer speeds. It supports multi-threaded copying, which can be especially beneficial when copying multiple small files.

Check for Software Issues: If you’re experiencing slow file access with specific software or applications, there might be software-specific issues at play. For example, some users have reported slow access to .mdb files with Microsoft Access. In such cases, you might need to troubleshoot the software or reach out to the software vendor for support.

Remember to always backup your data before making any changes to your system or network settings.