Unable to see my table in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I had an Access database created with Office 2000. I converted it to the
2003 format and started receiving the unsafe expressions dialog. I had been
hitting do not block and open anyway and was working with no problems.
However, today, I accidentally hit yes block the unsafe expressions and the
database opened. Since I have done this I cannot see my main table where my
data exists. The database seems to be working anyway and still storing the
information but I need to create queries, etc and I can no longer pick this
table from list as it does not show anymore. Does anyone have a clue as to
what happened? I can hit the relationship icon and see the table there but I
really need to be able to get to this easy. My existing queries, forms, etc
that are using this table show the table in design view but I would rather
not have to open an existing query to create new ones as a work around. Any
help is greatly appreciated!
 
I'm not sure how this could relate to your choice to block in the unsafe
expressions dialog, but it sounds like the hidden attribute for the table
has been set. To check this (at least in Access 2002), go to the menu bar,
Tools, Options, and then the View tab of the dialog where in the Show area
you can check Hidden and press OK. If you're lucky, the table icon should
now be visible in a slightly grayed out fashion. Right click on the table
and choose properties. Then, uncheck Hidden and press OK. Hope that's all
it is.
 
I'm getting an unsafe expressions dialog box for one user only and I don't
have a clue why? Why him (and of course it's the big boss who's gonna nix
this project if it doesn't work by tomorrow).
 
Back
Top