Missing table in Access 2002

K

Kevin Chapman

I have a number of tables in a 2002 database. One table uses another for a
list of lookup values in a combo box.

The table it is looking up is CB_GROUPS with the following expression.

SELECT DISTINCTROW [CB_GROUPS].[CB GROUPS] FROM [CB_GROUPS];

This all works fine and the drop-down list appears etc etc. The weird thing
is that the table CB_GROUPS is no longer visible! I cannot see it / open it
to edit it.

I believe the database was started in Access 97 and converted to 2002 format.

I'd appreciate your help guys!
 
M

molsonexpert

Kevin Chapman said:
I have a number of tables in a 2002 database. One table uses another for a
list of lookup values in a combo box.

The table it is looking up is CB_GROUPS with the following expression.

SELECT DISTINCTROW [CB_GROUPS].[CB GROUPS] FROM [CB_GROUPS];

This all works fine and the drop-down list appears etc etc. The weird thing
is that the table CB_GROUPS is no longer visible! I cannot see it / open it
to edit it.

I believe the database was started in Access 97 and converted to 2002 format.

I'd appreciate your help guys!
Click to expand...

That table has probably been flagged as hidden. Click on Tools>Options>View,
and check the hidden objects box and click OK. It should appear and you can
access the properties for that tabl and remove the hidden attribute.

steve.
 
L

Lynn Trapp

If the combo box is working, then the table must still be there. It is
possible that it has become hidden. Go to Tools > Options > View tab and put
a check mark in the Hidden objects box. Click ok and see if your table shows
now. If the table shows up now, right click on it and select properties. You
will then see where the hidden property is set.
 
Top