>>>There is a problem with views though, in that the view record in the DBC is temporary locked when the view is opened. If two users are opening the view at the same time, one may fail. So many developers put their views in a separate DBC, and keep that DBC on the local machine. So there is one DBC on the server for the tables, and each user has their own copy of the view DBC.
>>
>>Is this only when the view is opened - not requeried?
>>
>
>I don't believe so because the view structure is already known and getting that information from the DBC is not necessary.
Did you mean to say, "I believe so"? Thereby answering his question as -- Yes the record is only locked when the view is opened and not when requeried.
Mark McCasland
Midlothian, TX USA