Linking to Hidden tables using Link Table Manager

[Eric Blitzer]

windows 2000
Office 2000 with all service packs
Split database

I have a table that I want to keep hidden. However when I make
modifications and want to relink the tables the hidden table does not show up
on the list in the Link Table Manager. Do I have to unhide this table
everytime I want to deploy a new front end and then hide it again?

Thanks

 

['69 Camaro]

Hi, Eric.

Do I have to unhide this table
everytime I want to deploy a new front end and then hide it again?

No. Select the Tools -> Options... menu to open the Options dialog window.
Select the "View" tab and mark the "Hidden objects" check box in the "Show"
section. Select the "OK" button to save the change and close the dialog
window. Now when you run the Link Table Manager, you'll see any hidden
tables and be able to link to them.

Every user who has the "Show hidden objects" option marked can see this
hidden table, too, so this isn't a very effective way to hide the table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.