The Microsoft Jet database engine cannot open the file ''. It is already opened exclu

[prabhus]

Dear All,

In my access query, i link an excel file from our share drive with the Query - When i share this query with Multiple user - While User1 using this query, if the second user tries to run the same query i am getting the follwing error msg. The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.
I tried sharing the excel file also. But still i am getting the same error; How to fix this.

 

[James Dudden]

Excel can't be used in a multi-user environment. To get round this issue try creating a table from the data in the Excel file and using that in your query instead.