I failed to state that this problem has also happened to tables also. My enviroment object sets exclusive off before it opens the database shared noupdate. The users report that they are unable to open a specific form (different each time). I open the database and browse the tables and views that are used on the form. Eventually I'll get to the view and recieve the following message: Attempting to lock record (SET reprocess to automatic) Press Esc to cancel. I press Esc and I get "Record is in use by another user".
95% of the time it is a view.e