Joe,
What do you mean "we can't get to the tables, queries, forms, reports
etc..."?
To begin with, is thedb file extension .mdb or .mde? In the latter case
there is nothing you can do with it; .mde's are converted .mdb's which do
not allow design changes, and are used by developers for distribution
exactly for that purpose. In this case, your only chance is to get hold of
the original .mdb from which the .mde was made, and make your changes there
(and then re-convert to .mde if desired). The catch is (apart from getting
hold of the original .mdb), if the database is not split (so the tables as
well as the forms, queries, reports etc. are all in the same file) then you
need to update the data in the .mdb before you re-distribute. To do so,
delete all the tables from the .mdb and import them from the .mde. In any
case, before you do anything back-up both!
If your database file is an .mdb: is the database window visible? If not,
hit F11 to make it visible (even better: open the database while holding
down the Shift key, so as to bypass all startup settings, macros and code).
If the database window is visible but you see no objects (or not all
objects) in it, follow menu path Tools > Options, and on th View tab check
the Hidde Objects box, so as to see hidden objects as well. Setting /
resetting an object's Hidden attribute is done by righ-clicking on it and
selecting Properties.
HTH,
Nikos