Re-Index SQL Server Express User Instance?

Is there a way to re-index a SQL Server Express User Instance? If I try to open the .mdf while the website is still running, I get a message stating that the file is in use. If I shut down the web service and open the .mdf, then restart the website, then the website cannot access the .mdf while I have it open in VStudio (reminds me a lot of Access).

In the past I tried to open a user instance with SQL Server Management Studio, but then it goofed up my user-instance...so I am hesitant to try that again. Is there any way to re-index?

Thanks!

Backup and restore and adjust Web.Config, then ALTER Table drop INDEX and REINDEX, the reason is currently your User Instance is behaving like a separate instance of SQL Server and that is not valid. Hope this helps.

http://forums.asp.net/thread/1454694.aspx