MS Access Error: Disk or network error.
One of our clients called and reported an issue with a MS Access database. The user was able to open a network based .mdb file, but when they tried to click on a switchboard button they received the following error message: "Disk or network error." There are many resources that deal with this error, but none of them provided the needed solution. The TMP/TEMP directories were set properly, the JET Engine was updated, and the .mdb file was not corrupted (verified on another computer).
Through basic troubleshooting, we determined that this .mdb file had many 'Linked' tables that were using a static network path mapped through drive E:\. The problem was occurring on a new machine that I quickly noticed did not have a mapped drive 'E:\' because E: was assigned to a secondary CD-R drive. For this machine, access to the network drive was a UNC path.
To remedy the problem, I had to have the MS Office XP disk to install the 'Linked Table Manager'. Once this was installed, I updated all linked tables to use the UNC path and not the static E:\ path. To my relief, it corrected the 'Disk or network error.' problem.
It's amazing how every resource on the Internet didn't help me address the most simple problem :)
Comments
Nice Blog
Very nice blog about network error in access. i have been facing this error but didn't get the proper reply. Your article solved my queries. Here is one more site where you can get details about error in access and access repair.
Thank You
Nice Blog
Very nice blog about network error in access. i have been facing this error but didn't get the proper reply. Your article solved my queries. Here is one more site where you can get details about error in access and access repair.
Thank You
What is UNC path and how do
What is UNC path and how do we change it from static E:// path.
Had the same problem on a
Had the same problem on a access 2000 db back in the day.. I linked all the tables to the drive c: took me forever to figure it out. How many clients are accessing your db. I had upto 15 on a single database. Never saw anymore than that because I updated to a web based system using mysql and php. I liked access.. but doing updates to it ment I had to take it completly down.
Part of the problem here is
Part of the problem here is Microsoft's perennial problem of providing absolutely worthless error messages. "Disk or network error" contains no actual information, so it's worthless, and even if it were more specific, if still obscure, you can at least Google it to find out what was going on.
Frustrating..
Just wanted to point out
Just wanted to point out that you could have used Tweak XP to modify the path for the CD-R drive to open E:\
But then I'm sure that would cause a few issues with any programs that were installed with the CD in that drive.