I have created client server visual basic application, in which I am allowing to drop thedatabse to user. It works fine when a single user is working on it, but it gives problem at same time multiple user working on same database and one of them want to drop the databse. It gives following error
"-2147217900 (80040e14) can not drop the database, it is currently in use....."
How do I prevent this?
Is there any way to know someone is using the database? or I can lock the database ? So I can give the error message accordingly?...