We have a linked server setup to an Access databases that is on a Netware box. We are continually losing connectivity to the database via SQL server, which causes obvious errors at the front end. I am always able to browse to the .mdb file through explorer.

Other than migrating the Access data, is there anything I can do to make this a little more stable. I saw in BOL that there is some replication functionality that is available to work with an Access file.

Any help or advice would be great.