Hidden tables

[Barry]

What are the ramifications of hiding tables? For
example, will that have any impact on refreshing links
between the front and back ends? Is there any concerns
with a secured database? Thanks in advance to anyone who
replies.

 

[Jeff Mastey]

As far as I know, hidden tables only affect GUI settings, i.e. whether
people can see them in the database window, make queries using the Query
Designer, or import them into another database. They can still be accessed
through VBA code at any time.

 

[Van T. Dinh]

Hiding Tables simply prevent *inexperienced* users to muck around with them.
However, it is NOT a security measure since anyone with a bit of experience
in Access will be able to unhide them.

If you want to secure your database, implement Access security / network
security and use MDE format.

 

[Barry]

Jeff, thanks very much for the advice.

-----Original Message-----
As far as I know, hidden tables only affect GUI settings, i.e. whether
people can see them in the database window, make queries using the Query
Designer, or import them into another database. They can still be accessed
through VBA code at any time.





.

 

[Barry]

Van, thank you very much for the advice.

-----Original Message-----
Hiding Tables simply prevent *inexperienced* users to muck around with them.
However, it is NOT a security measure since anyone with a bit of experience
in Access will be able to unhide them.

If you want to secure your database, implement Access security / network
security and use MDE format.

--
HTH
Van T. Dinh
MVP (Access)






.