Hi, Phil.
Just in case you stumble upon the VBA code that hides the table from users'
view, please take Doug's statement as the truth. There are places on the
Web where the code is available, but the warning doesn't accompany the code.
The problem with the code is that it uses a table attribute to mark the
table as "deleted." Any object marked as deleted will not be displayed in
the database window.
The table can still be used as a record source, but the users won't be able
to see it. This sounds like a great idea -- up until the day the database
is compacted and all objects marked for deletion are removed from the
database, including that "hidden" table. Bye-bye data.
There are other methods of hiding the data from users. Just don't use this
one for your table.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:Ac*******************@twister01.bloor.is.net. cable.rogers.com...
I don't believe it's possible.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:41***********************@mercury.nildram.net ... Can anyone give me the VBA code for making a table completely invisible
so that Tools-->Options-->Show System Objects or Show Hidden Objects still
won't show the table object. It should only be possible to show it
through code.
TIA
Phil