This seems like an odd setup. Is there some reason you have multiple copies of the database? You say that the user keeps working if the server is down... does this happen frequently? Is this a shared database?

As for the Error Reading File message... once you get this, the only way to recover is to restart the application.

Wayne


>I have a system which works on a database which is located on a file server.
>The system also have a local copy on the local disk. The difference is that the files on the local system aren't updated very often due to the fact that these are large databases. So i only need to use the databases on the local disk for emergencies only(ie - When the connection with the server fails)
>
>My problem is that i open the form which contains the tables looking a path on the server. Now when the connection with server fails in need to close the form and open the same form but this time with the paths looking a the local hard disk. The problem is that when i try to close the first form it gives me an error 'Error Reading file' and i cannot continue anymore.
>
>How can i manage to do this without giving me these errors.
>
>Thanks