Access Database won't open on screen - but running in background.

[Guest]

When I came into work this morning and tried to open the database, I got a
message something about it may have not been closed properly and did I want
to repair it. It closed fine when I finished working on it last night, so
I'm not sure what that was about . . . but I clicked yes. Now it's gone. I
can see it in Windows Explorer, but when I double click on it to open it, it
does nothing. I tried opening it from the MSAccess application and same
thing, nothing.

Interestingly, this database is a repository for a Microsoft InfoPath form.
Then a SharePoint site reads data access pages fromt this database. I went
to the form, added a new record and received a message it was submitted
succesfully. I clicked the refresh button on the SharePoint toolbar and
whola! the information on the data access pages updated with the record I
just submitted.

I went to task manager and it does say it is running. I went to Processes
and ended it. I tried to open but same results. Then I rebooted my PC. I
opened MSAccess, clicked on the file name to open - got an hour glass for a
split second (a flash of hope!) then nothing. Again, it is showing up in the
Task Manager as running under both Applications and Processes.

Does anyone know how I can get this to show on my screen?

 

[Guest]

If all else fails, try importing all the objects into a new DB.

Steve

 

[Guest]

I already tried that and I get the same behavior. It sees the database name
and I click on it . . . but it does nothing.

 

[Guest]

You have a backup right?

What is in the DB, just tables, forms etc?

Steve