Hi UniqueDoug,
Try the following KB article:
How to retrieve a lost or hidden Database window in Microsoft Access
http://support.microsoft.com/?id=314598
If that doesn't work, then try creating a brand new database, and then
import all objects, one group at a time, into your new database. In other
words, import all tables (but not linked tables), then import all queries,
then all forms, etc. While Access will allow you to import all objects in one
operation, the experts at FMS, Inc. (a Microsoft Partner), have stated that
it is best to import objects one group at a time. Recreate any linked tables
from scratch. When importing local tables, make sure to check the option to
import relationships, menus and toolsbars, and import/export specs. If any of
the local tables in the source DB are hidden, you'll need to first unhide
them.
You will need to set the checked references to match the source database,
along with any startup options set under Tools > Startup. You should disable
Name Autocorrect after creating the new container database. Going through
this process often times solves corruption problems, because you get a new
set of the hidden system tables (the tables whose names start with "MSYS").
These system tables are updated appropriately as you import objects.
This may sound like a lot of work, but it really isn't. Creating a new
container DB, disabling NameAutocorrect, importing all objects one group at a
time, and setting startup options and references to match the source DB is
usually a fairly quick procedure. When you are in the Visual Basic Editor, in
order to check that the references match the source DB, you should do a Debug
Compile ProjectName as well. You want to re-create any linked tables from
scratch, because Access can cache a lot of information about the links. Some
of this infomation may no longer be valid, so it's always best to recreate
the linked tables from scratch.
Good Luck,
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
