MS ACCESS “Disk or Network error”

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!
Will_NYCAnalystAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
0
Will_NYCAnalystAuthor 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.
0
John TsioumprisSoftware & Systems EngineerCommented:
this abnormal behavior usually is not related to Access...
I would swap NIC/cables/check the switch for dropped packages
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Will_NYCAnalystAuthor 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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<they replaced some hardware the problem was resolved.>>

 Very good!

Jim.
0
Will_NYCAnalystAuthor Commented:
I am grading myself
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Networking

From novice to tech pro — start learning today.