>You have to be careful with this as the database could have been opened exclusive. In this case, if I remember correctly, the table is opened EXCLUSIVE also.
>
>>USE .. SHARED opens a table in non-exclusive mode, even if SET EXCLUSIVE is ON.
You remember correctly and Cyrus should be aware of the point you've made. Nevertheless, table and database containers are at different levels. When the database is opened excusively, it's the access to the container that is denied and that does not look like Cyrus' scenario: if a database container is openend exclusively there is no way another user or process can open any of its objects as shared resources.
And going back to the first question Cyrus posted, what applies to tables also applies to databases: even if SET EXCLUSIVE is ON, you can OPEN DATABASE x SHARED and it will be opened in non-exclusive mode.
----------------------------------
António Tavares Lopes