MS Access 2003 - Disk or Network Error - NOT a Network Issue - Remote App - Win 2008

Question

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:

1. Copied offending DB to local computer.
2. Renamed to add TEST1 to file name.
3. Copied back to server.
4. Updated RemoteApp shortcut to look at new file name.
5. 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.

Answer 1

I encountered this error and post after I created a new 2008 R2 server, and restored a backup of a 2005 Database.

I then imported all users, maintainence plans etc, but I got this error as I had forgotten to change the default language from US English to British English.

After the migrate I had to :

1. refresh statistics with : exec sp_udatatestats
2. set default laguage with : EXEC sp_configure 'default language', 23

3. using the below code (I should link it but i forgot where I got it from) I changed all users language

   declare @l table(sqlCmd nvarchar(max)) declare @sqlCmd nvarchar(max) insert @l select 'alter login ' + quotename(loginname) + ' with default_language = British;' from sys.syslogins where dbname = 'XXXXXXXXXXXX'

   select top 1 @sqlCmd = sqlcmd from @l while (@sqlCmd is not null) begin print @sqlCmd exec(@sqlCmd) update @l set sqlCmd = null where @sqlCmd=sqlCmd set @sqlCmd = null
   select top 1 @sqlCmd = sqlcmd from @l where sqlCmd is not null end