You can check for open connections to the database through Activity Monitor or using sp_who2 through a query window.

You can kill open connections to the database using the kill command. Once there are no connections to the database you should be able to make the change.

It is possible that another connection is using the database using 3 part naming through another database so bear that in mind