See, for example:
http://support.microsoft.com/kb/209189
However, given that many databases allow multi-user access, simply know that 'someone' has such a database open isn't of much use, since that doesn't prevent someone else opening the same database; all that gets locked in such instances are the records in use.