Opened exclusively error on split database?

[gmworrall]

I have a multi-user database.

I've split it into a front-end and back-end. Distributed copies of the front end to each user. Thought I was sorted...

However if I try to open, in any view, a query that somebody else is using, it comes up with the 'Opened exclusively by another user' error.

Any thoughts on what I've missed?

 

[G37Sam]

Are the queries on your backend or frontend?

 

[gmworrall]

Are the queries on your backend or frontend?

Front-end. Back-end just has the tables.

 

[gmworrall]

Just realised something else which might be important:

One of the linked tables is NOT in the backend database, but links to a CSV file. It also has the 'opened exclusively' error when I try to open it. The rest of the 'normal' tables are fine. Are linked CSV's known to cause issues in multiuser DB's?