By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,987 Members | 997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,987 IT Pros & Developers. It's quick & easy.

Hide a table

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.