I am unable to open the database window when using my database with
the run-time only version of Access. I would normally do this with the
F11 key when working with a full version of Access. This database has
not been developed to the point when I have queries/forms created for
all of the functions it will perform, so I need to open some tables
directly to input data.

I can make a command button that runs a 'DoCmd.OpenTable ...' to open
a given table, but I do not want to make 20 or more of these. What I
would like to do is create a combo box that lists all of the tables in
a database, then create one command button to open a given table based
on the selected item in the combo box.

Can somebody give me a hand in doing this, or give an example of a
better way to do this?

Thanks in advance....

Mike

: My problem is this:
:
: I am unable to open the database window when using my database with
: the run-time only version of Access. I would normally do this with the
: F11 key when working with a full version of Access. This database has
: not been developed to the point when I have queries/forms created for
: all of the functions it will perform, so I need to open some tables
: directly to input data.

Access xx Developers Handbook (xx==Access version) contains a replacement
for the database window for all the db objects.  If you are running Access
97 and plan to upgrade, then use the TabeDefs and QueryDefs collection of
the database to get a list of all the Jet objects.

  -- Dev