We have a Windows 2008 running terminal services, but as remote apps, not full desktops.
There is a single database file, calc.mdb, that gives "Disk or Network Error". If it is accessed by a user with MS Access 2003 installed, it runs just fine. However for our traveling users that access via the RemoteApp, then they get "Disk or Network Error".
I have searched and just about everyone comes to a couple of conclusions:
1. It's a network error.
2. Recompile and/or compact it.
It is certainly not #1 because I can verify that the network is fine.
I have recompiled and compacted with no success (and besides you can open the database).
From a client computer:
A) Has no issue running another RemoteApp (such as Word, WordPad, or even another Access DB)
B) Has no issue logging in via full remote desktop.
C) Can run the database from Access 2003 locally installed
D) Receives "Disk or Network Error" when opening via Remote-App.
The event log shows nothing of any help that I could find. With all the various logs in Windows Server now, maybe somewhere else to look? It certainly seems related to the RemoteApp setup.
Again, this is NOT A NETWORK ISSUE! This has been going on for months. I have verified it is not a network issue.
And yes, as soon as I complete my current project, the next is to update these aging apps.
EDIT: Additional Test based on comment:
- Copied offending DB to local computer.
- Renamed to add TEST1 to file name.
- Copied back to server.
- Updated RemoteApp shortcut to look at new file name.
- It works!
So simply copying the file and renaming makes it work. However, I tried the same steps without changing the name (basically copy it to local and copy/overwrite right back to server) and that does not fix the issue.