Query can be opened Exclusive through query designer?

[1RobDog1]

I have built a very complexe report to report out position control with various information on there. Basically I have a single query that drives the report and has joins to other tables etc... Well it is in a mulituser environment and so some users may have opened the report and lock others out with the message that its opened exclusively. Well that want work. I need everyone to view the report at will. I traced it down to the query. When it is locked the query is what gives me the message that its opened in exclusive mode. Now there is two piece to this database. Position Control is one. The other is Product Management Reports. Well everyone can open the database and view Product Management Reports all day long. But if multiple users view Position Control again it opens it up in exclusive mode. Can anyone help or have an idea as to what is wrong or how to correct this problem? Everything in the database needs to be shared each time users enter and exits. They are only viewing reports and not editing the database. Our ME(Management Engineer) is the one who will
be editing it.

Again TIA,
-Robert Thanks
-Robert
System Analyst/Programmer

 

[JoeEskimo]

Does 2 parts mean 2 databases?

 

[1RobDog1]

No sorry just 1 database. The PMR works great in the same database. But, the position control is a seperate piece n the same database. They are seperate pieces because they both have different data sources like tables, queries, linked files etc... The report gets it main data from a single query that was built up from other steps. It is this query called Q_PositionControl that is being locked up for exclusive mode when a user views his/her report. The database is located out on the network and each user has read/modify/write rights. As I said before though everyone can get into it and see like all PMR reports but when they look at the R_PositionControl report it gets locked out by the exclusive mode bit... Thanks for any help your able to give. Thanks
-Robert
System Analyst/Programmer