Hi Ria,

It's a matter of tracking it down, I'm afraid. However, is it possible that you're executing a SQL query with EXCLUSIVE ON somewhere? Any table in the query that isn't already open will be opened exclusively. Just a wild guess. Good hunting.

Regards,

Liam



>The feature is actually not avilable for the rest of the day. After the automated program runs at night and fills the tables with new data everything is ok.
>
>Now I am trying to reason this out.
>
>1. Did a user have the file opened exclusively?
>
>The users can query the database only through my program. The program has set Exclusive OFF and opens the database and all the tables in shared mode. How then can a user have the table opened exclusively?
>And if this is the case, when the user logs off that evening, he would release the table and the automated program would run successfully that night.(The automated program zaps the database and needs exclusive access to it).
>
>As you suggested, the next time this happens, I could ask the systems to verify who has the table opened. But how do you think that this user managed to have a table all for himself? My application is not updating/adding records to the tables, it just executes Select queries on the tables.
>
>Thanks a bunch.
>
>Ria