>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
My guess is that the table problem happens when a view is updating the table.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer