Unhide Tables in Acc2k7

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"an" wrote:

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

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

"Jerry Whittle" wrote:

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"an" wrote:

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

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" wrote:

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

"Jerry Whittle" wrote:

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"an" wrote:

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

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" wrote:

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" wrote:

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

"Jerry Whittle" wrote:

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"an" wrote:

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