How do I go about detecting whether another user has opened up a database
connection?

I'm using ado 2.5 to connect to an Access 2000 database and I'm wanting to
detect if another user has opened a connection with the database. If so,
the other person will not be permitted to open the database. So essentially,
it's a networked single user application. Odd yes, but the situation calls
for this sort of app.

Thanks,
Chris