>Hi,
>
>ODBC is being used to connect Back-end database.
>I want to acquire an exclusive lock on this database at run time (without dropping and re-creating the DSN).
>
>How do I go about doing this.
>
>Loy

Back-end databases are specifically designed for concurrency. Typically you use transactions to make changes; if the backend accepts all your changes as a group, they are committed, if not, you can rollback and try again.

With a backend server, you're talking to another program, not just a group of files like in xBASE. That backend program is responsible for handling locks. In a production environment, it may be impossible to gain an exclusive database lock. Some backends may not even support an exclusive database lock, even from its console.

What are you trying to do?