Hi guys. I've included the previous part of this thread below. Sorry to take up the bandwidth, but it's been long enough that I even had to re-read to remember what we were talking about and I'm on the project :) My life is crazy lately.... Y2K 3 days here, Y2K 2 days there and hours grabbed in the office working on actual development when I can.

Okay, I've done some tracking down of exactly what my error message is and when the thing dies. Maybe that will be enough that you'll be able to help me figure out what's going on. First off, this happened when a co-worker and I were sitting at separate computers across the hall and clicking the buttons at the same time (you know, "we're going to click this button... 1...2...3...click"). So it's not a problem related to me trying to simulate 2 users on my machine.

I have this form that goes out and grabs information out of 4 tables. The tables are Access tables being accessed through a database connection which is hooked to a DSN (hope I'm using all the right terminology here). The way that I'm accessing the tables is through the four views -- viewencumb, viewprocmethos, viewcategories, viewcostdist. The viewencumb and viewcostdist views are parameterized if that matters.

These four views are in the data environment for my form. The message I'm getting is the one about "Error loading file .... frmSpecPend Loading form or the data environment: Database object is being used by someone else."

Maybe it's not the view that things are crashing against but the database container that holds the view? But that wouldn't make sense because I can use tables shared without having to make sure I'm using the database container non-exclusively?? Maybe it's the connection that is the problem? Maybe there's some way to use it shared?

Any help you can give me would be greatly appreciated. Hope I've given enough information. Thanks in advance.

========== PREVIOUS PART OF THE THREAD =================
>>>>Every copy of a view you open will open exclusively, but that's ok, because a view isn't a shared resource. (A view definition is). Don't worry, your app will be fine.
>>>
>>>Okay, then maybe I'm not really understanding what's going on. I was doing multi-user testing the other night on the app and was getting a lot of "you can't have it, someone else is using it" messages. So that's when I found that the views were opening exclusively. And that's when I figured that must be the problem. Is there something else I should be looking at? Thanks.
>>
>>There is no such things as having exlusive access to a view definition. You have exclusive access to the view, yes, but that's because the cursor that your view creates is its own copy that lives on your disk (or in your memory), and noone else can see it.
>>
>>Your contention problems lie else where. What are the exact errors you are getting, and when?
>
>I bet that she was switching to another session on her machine and running the app again?
>
>__Stephen

~~~~~~~~~~
Denise
~~~~~~~~~~