Troubleshooting slow network and Microsoft Jet database issues on Windows Vista/7/2008 Server

Modified on: 2017-06-12 15:50:57 -0400


Troubleshooting slow network and Microsoft Jet database issues on Windows Vista/7/2008 Server peer-to-peer network or dedicated server with a shared folder.

  1. Verify that the problem exists (problem should exist on the workstation but not on the server).
  2. Check for the proper msjet40.dll files on the server (should be 4.0.9704.0 or higher). Server is the machine that has the DM directory and .mdb file on is local hard drive.
  3. Backup the database (make a copy into another directory).
  4. Repair and compact the database (run repair.exe from the server).
  5. Synchronize the database schema (run FPASync.exe from the server)
  6. Check for the proper msjet40.dll on the workstation computer computer
  7. Verify the problem still exists on the workstation computer computer.
  8. On the workstation computer, verifying the problem still exists between each step…
    • Run IPConfig, verify an IPV4 or IPv6 setup. Check Network Adapter properties and make sure that IPv6 is not enabled (if IPv4 is being used, otherway if use IPv6). Make sure that the wired and active adapter is the only enabled adapter and disable any wireless adapters. Verify proper DNS.WINS and IP address.
    • Disable TCP Autotuning, reboot
    • Disable TCP heuristics, and re-confirm Autotuninglevel setting, reboot
    • Remove Remote Differential Compression, reboot
    • Clear the local DNS cache, reboot
    • Modify the Network Adapter’s link speed and Duplex to a hard coded value or to Auto Negotiate (try a few settings)
    • Temporarily disable Windows Firewall, Antivirus, etc.


Did you find this helpful? Yes No

Can you please tell us how we can improve this article?