Hi Tony,
That 'mSysAccessStorage' is, I believe, one of the hidden tables used by
access. You can go into the options and view all those system type objects,
but not if you can't get into the database.
The first thing I'd try to do is holding the shift button down as you open
the file. If it's an unsecured db, then hold down shift when you
double-click the file icon. If it's secured, hold the shift down while you
are hitting the 'ok' button right after typing in your password. If you get
in, immediately compact and repair your database (Tools>Database
Utilities>Compact and Repair). Hopefully, that will fix it.
If that doesn't work, I'd probably try making a new database and see if you
can import all the objects out of the old one. In a new database, go to
'file', then 'get external data', then 'import'. Then navigate to wherever
your messed up database is and see if it will let you import the objects. If
it will, just click on each tab in the window that opens, choose 'select all'
and then move to the next tab and select all....until you have all objects on
all tabs selected. You might want to check the 'options' and make sure that
the 'import definition and data' is selected, as well as import
relationships. Queries should be imported as queries as well. That should
all be set as default I think.
After you have checked the options and selected everything, import it all.
If everything works, and your old/broken db was secured, you'll have some
things to set back up in the security...
Good Luck,
CW
