Thanks in advance for your help.

When trying to access the sql server database thru SSMS, I am getting the following message "The database SMSProductionSQL is not accessible. (ObjectExplorer)". Yet, I am able to INSERT/UPDATE/DELETE the database using an ACCESS frontend application.

I am new to SQL Administration, and am at a lost. What could possibly cause this problem? Where should I look first? I am using SQL Server 2008 Express.

Again, thanks for your help.