467,888 Members | 1,579 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,888 developers. It's quick & easy.

Cannot see tables even though they are there

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?

Jul 3 '06 #1
  • viewed: 14487
Share:
3 Replies
AP
Maybe try going to the tools...options,,,view.. hidden objects.
AP
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''
For access tips
http://www.greenixsolutions.com/tips.html
www.megacrosstab.com

davidanthonyedwa...@googlemail.com 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?
Jul 3 '06 #2

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?

Jul 3 '06 #3
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?
Jul 3 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

44 posts views Thread by Mariusz Jedrzejewski | last post: by
31 posts views Thread by Neil | last post: by
10 posts views Thread by Jim Devenish | last post: by
5 posts views Thread by rdemyan via AccessMonster.com | last post: by
22 posts views Thread by amygdala | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.