Unhide Tables in Acc2k7

  • Thread starter Thread starter an
  • Start date Start date
A

an

Hi!

How do I unhide tables in the Acces2k7, please?

When I try:

Navigation Pane, Access Options, Navigation Options, the Groups for "Tables
and Related Views" is empty.

Thanks in advance.
an
 
Do they show up if you select Object Type instead?

Try Office Button, Access Options, Current Database, Navigation Options
button. When that window opens, select all the Display Options at the lower
left of the window.

If that doesn't work, make a copy of your database and hide it away in a
safe place. Then do a compact and repair. If that doesn't work, open a new
databasse file and import everything from the old database to the new one.
 
Thanks for reply.

All attempts were made unsuccessfully.
When importing to a new database, the tables are not visible.

In additions:
Only import modules and queries to a new databse

an
 
Run the following query and see what it returns. 1's are local tables. 6's
are linked tables.

SELECT MSysObjects.[Type],
MSysObjects.[Name],
MSysObjects.[Database]
FROM MSysObjects
WHERE MSysObjects.[Type]=6
Or MSysObjects.[Type]=1
ORDER BY 1, 2;
 
JW,
Sorry for my delay but the check 'Notify me of replies' don't work fine.

Your query return:

9 MSys... tables
2 tables: tblName and tblNew.

Thanks in advance.
an


Jerry Whittle said:
Run the following query and see what it returns. 1's are local tables. 6's
are linked tables.

SELECT MSysObjects.[Type],
MSysObjects.[Name],
MSysObjects.[Database]
FROM MSysObjects
WHERE MSysObjects.[Type]=6
Or MSysObjects.[Type]=1
ORDER BY 1, 2;
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


an said:
Thanks for reply.

All attempts were made unsuccessfully.
When importing to a new database, the tables are not visible.

In additions:
Only import modules and queries to a new databse

an
Click to expand...
Click to expand...
 
Back
Top