Cannot see tables even though they are there

[davidanthonyedwards]

Please Help,
I have been given an Access application to have a look at, am newbie,
etc.

When I open the mdb file with the shift key down so that the menu
options are available I can see all the reports, queries, forms and
there are plenty. But I cannot see any of the tables, as you would
normally, and I think there are up to 40.

I can find the table names from viewing one of the queries and then
viewing Object Dependencies but that would be a very long process. Or
from viewing a query in Design View. Or when I look at a query in SQL
view then the table names are there e.g" [Table Contact_Info]"

But I cant see the tables as I would expect to normally, i.e when I
open Access and it allows me to see Tables, Queries, Forms, etc.

Any ideas why not?

[AP]

Maybe try going to the tools...options,,,view.. hidden objects.
AP
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''
For access tips
http://www.greenixsolutions.com/tips.html
www.megacrosstab.com

[e-mail] wrote:

Please Help,
I have been given an Access application to have a look at, am newbie,
etc.

When I open the mdb file with the shift key down so that the menu
options are available I can see all the reports, queries, forms and
there are plenty. But I cannot see any of the tables, as you would
normally, and I think there are up to 40.

I can find the table names from viewing one of the queries and then
viewing Object Dependencies but that would be a very long process. Or
from viewing a query in Design View. Or when I look at a query in SQL
view then the table names are there e.g" [Table Contact_Info]"

But I cant see the tables as I would expect to normally, i.e when I
open Access and it allows me to see Tables, Queries, Forms, etc.

Any ideas why not?

[davidanthonyedwards]

AP wrote:

Maybe try going to the tools...options,,,view.. hidden objects.
AP
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''
For access tips
http://www.greenixsolutions.com/tips.html
www.megacrosstab.com

Thanks very much AP, any idea as to why would these be hidden in the
first place? Is this something a developer would do? And why are they
'hazy' now when I see them?

[AP]

Hello
Glad the tip worked for you. Its really a matter of personal
preference. I think some developers make certain tables invisible so
they arent as easily accessible by users. The haziness that you refer
to are because they are still hidden tables. You have simply made all
hidden tables visible by setting the option. If you right-click on a
table and select properties, you can uncheck the hidden box and they
will no longer appear hazy, and will appear all of the time.

AP
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''*''''''

For access tips
http://www.greenixsolutions.com/tips.html
www.megacrosstab.com



da*****************@googlemail.com wrote:

AP wrote:

Maybe try going to the tools...options,,,view.. hidden objects.
AP
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''
For access tips
http://www.greenixsolutions.com/tips.html
www.megacrosstab.com

Thanks very much AP, any idea as to why would these be hidden in the
first place? Is this something a developer would do? And why are they
'hazy' now when I see them?