Hiding tables

[Guest]

Sometimes I develope my database at home, sometimes at work. When at home, I
don't have access to the ODBC and other linked data sources I rely upon. So,
using Linked Table Manager, I point the linked tables at locally held copies
of the data when working offline.

Bizarrely, hidden linked tables become unhidden when their link source
changes. This is annoying, as I have about twenty and want to keep them
hidden. I cannot select more than one table simultaneously using the GUI (I
am using 2003 SP 2), so my question is:

How can I select and hide more than one table simultaneously, so as not to
be forced to hide each table individually?

OR

How can I hide tables programatically, using either a macro or code which I
can then run whenever I have updated my links?

 

['69 Camaro]

Hi, Rod.

How can I hide tables programatically, using either a macro or code which
I
can then run whenever I have updated my links?

Use the SetHiddenAttribute method in a VBA procedure. Try:

Application.SetHiddenAttribute acTable,"MyTable", True

HTH.
Gunny

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