Access 2010 split db network problem
Posted on 2013-01-11
I have made a database for my employer. This is an Access 2010 splitted database. We are using an ASP provider, every employee (about 12) are using a virtual desktop on their machines. They have their own FE on their desktop, the BE also resides on the ASP desktop in a shared folder (T:\database)\database.accdb). The FE is a ACCDE, the BE ACCDB.
The ASP are using Windows Server 2008 R2 Standard (64-bit).
Sometimes (from none to several times a day) there's a network error and the database gets corrupted. Usually the problem are solved when copying the BE to the desktop and then back again (overwriting the existing database).
Error: "your network access was interrupted. To continue, close the database, and then open it again."
I suspect (after googling some hours) that the problem is caused by short delays in the network signals. But what to do with it...