open database and can't see tables

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

Guest

I have a database that contains about 50 tables. I opened it on Friday and could not see any of the tables. I have a shortvut to one of the tables and this works OK. I have tried checking the view hidden box on the tools >options but this has not worked. Anybody help?
 
Is there a chance that someone hid them by setting the Hidden property in
code? This hidden property works differently than the one when you check the
hidden box in the table's properties sheet.

Try creating a new database and import all the objects into it. Do they show
up? Is it just the tables or does the problem appear with other objects as
well? Do you have a backup copy of your file in case this one is corrupted?

--
Wayne Morgan
Microsoft Access MVP


kerry said:
I have a database that contains about 50 tables. I opened it on Friday and
Click to expand...
could not see any of the tables. I have a shortvut to one of the tables and
this works OK. I have tried checking the view hidden box on the tools
 
-----Original Message-----
Is there a chance that someone hid them by setting the Hidden property in
code? This hidden property works differently than the one when you check the
hidden box in the table's properties sheet.

Try creating a new database and import all the objects into it. Do they show
up? Is it just the tables or does the problem appear with other objects as
well? Do you have a backup copy of your file in case this one is corrupted?

--
Wayne Morgan
Microsoft Access MVP


opened it on Friday and
could not see any of the tables. I have a shortvut to one of the tables and
this works OK. I have tried checking the view hidden box on the tools


.
Check may be the table names starting with USYS* so
Click to expand...
tables will be hidden, if like this then goto
Tools;Options;then click on System objects.
May be it will work.
 
I have a database that contains about 50 tables. I opened it on Friday and could not see any of the tables. I have a shortvut to one of the tables and this works OK. I have tried checking the view hidden box on the tools >options but this has not worked. Anybody help?
Click to expand...

What Access version? I've had this kind of problem (in all the
database windows, queries, tables, ...) occasionally in AccessXP. SO
FAR (knock wood) I've been able to just click one of the other tabs
(say the Queries) and then click back to Table and they'd reappear.
 
Thanks Wayne

I went in to work today and created a new database and imported into it. I didn't have a back up but do now. It is possible that someone had hid them by setting the hidden property in code as the database is available over a network. Ho could I tell if this is the case

Regard

Kerr
----- Wayne Morgan wrote: ----

Is there a chance that someone hid them by setting the Hidden property i
code? This hidden property works differently than the one when you check th
hidden box in the table's properties sheet

Try creating a new database and import all the objects into it. Do they sho
up? Is it just the tables or does the problem appear with other objects a
well? Do you have a backup copy of your file in case this one is corrupted

--
Wayne Morga
Microsoft Access MV


kerry said:
I have a database that contains about 50 tables. I opened it on Friday an
Click to expand...
could not see any of the tables. I have a shortvut to one of the tables an
this works OK. I have tried checking the view hidden box on the tool
 
In the immediate window (Ctrl+G) type

?CurrentDb.TableDefs("TableName").Attributes

You will probably get 0 (zero) back. If the answer is 1, then it was hidden
using code. If the value is something else, such as an attached table
(1073741824), you will need to add the possibilities together and see if the
sum matches.

You will find some more information on this here:

http://www.mvps.org/access/bugs/bugs0036.htm

--
Wayne Morgan
Microsoft Access MVP


kerry said:
Thanks Wayne,

I went in to work today and created a new database and imported into it. I
Click to expand...
didn't have a back up but do now. It is possible that someone had hid them
by setting the hidden property in code as the database is available over a
network. Ho could I tell if this is the case.
 
Back
Top