Hi,

We have a program that runs every night, and it updates a database on the server with new data. And during this time, the application requires exclusive rights to the database. Many times it has happened that, when the job kicks off at the pre-set time, it finds that there is a user accessing the database and since the application cannot open the database exclusively, it aborts with an error message.

I believe that most often, the users might have another application that accesses this database running, while the night job is trying to start. I am trying to see how we can resolve this.

- Can I send a message to the users asking them to close the other application ?
- If the other application is running unattended, can I forcefully make the user exit from that application?

I would really appreciate it, if you could suggest other ways to resolve this.

Thanks in advance.

Ria