On our production server (SQL Server 7.0) we have a linked server that uses an ODBC connection to connect to an Access database which has a linked table which points to another access database.
We have many users with .mde front ends using SQL Server for the back end.
There is a view that uses the linked server for it's data source. The view is used to populate dropdown lists in the front ends so the users can select their employee names.
The problem I am having is I am trying to create the same setup on a test server and I can not get it to work.
The production server does not create any lock files on the Access databases.
When I set up the same thing on the test server there is a lock file created when I set up a linked server.
How do I set up a linked server so that there is no lock file created on the Access database that it is connecting to?