MS ACCESS “Disk or Network error”

Will_NYC
Will_NYC used Ask the Experts™
on
The problem is, an MS ACCESS Transaction DB “Trans.mdb” on “PC-A” updates the tables on “Master.mdb” over the LAN on “Server-A” “Share-A”. A “Disk or Network error” message is received. If I take “Trans.mdb” and copy it to “PC-B” it successfully updates “Trans.mdb” over the LAN with the same network and userid signon, on “Server-A” “Share-A”.  Some user’s using the same MS ACCESS process do not experience any problems.

I also observe that certain PC’s have huge download times over the LAN “Server-A” “Share-A”, even thought I can download the same file on other server is relative short times.

Any help would be appreciated. Thanks Will!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
Will,

  "Disk or network"  error simply means that JET lost a connection to the database.

 Sounds simple enough, but this can be exceedingly difficult to track down.  Anything that causes a network interruption (bad connector, cable, port, NIC driver, etc) can cause this as well as network connection.

 Then there are things in software as well, like NIC drivers that include diagnostic or power features that cause the NIC to disconnect momentarily, then re-connect.

 There's also things like the inactivity timeout built into windows, which will disconnect shared drives after a certain period.

 Access due to it's nature will complain about network problems far sooner than other apps.    So a couple of fast things:

1. Look at the networK interface card (NIC) on the machines and disable any diagnostic or power features.

2. Try a continuous ping for a period of time from one of the problem stations to the "server" and see if you can see any packet loss.   From a command line:

  Ping <ip> -t


 let it run for about five minutes, then do a control/c.    You should see times of less than 10 ms and zero packet loss.

3. check all connectors and patch cables.

4. Look for patterns; always certain stations, time of day, operation performed, etc.

Jim.
Will_NYCAnalyst

Author

Commented:
Jim,

I tried the ping <ip> -t . The PC that I try to copy and paste a file from the server has a faster average 15ms speed, but times out when trying to paste the file.

This is still unresolved and I am very disappointed with the experts-exchange.com site.

Thanks,

Will.
John TsioumprisSoftware & Systems Engineer

Commented:
this abnormal behavior usually is not related to Access...
I would swap NIC/cables/check the switch for dropped packages
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Analyst
Commented:
I finally convinced Verizon after 2 months that there was a problem with their switching hub and after they replaced some hardware the problem was resolved.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
<<they replaced some hardware the problem was resolved.>>

 Very good!

Jim.
Will_NYCAnalyst

Author

Commented:
I am grading myself

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial