hide objects

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
can we hide objects (table, form, etc) in an ADP?

Regarding to SQL Server objects (tables, SPs), in ADPs all the security is
defined into SQL Server. You can "see" tables because you have the permission
to "see" them.

Instead, regarding to Access objects (forms, reports, macros, DAPs) you can
use Access Security (MDW file) to define who can "see" what.
 
If you're strictly looking at "hiding", as opposed to "securing", for Access
objects, you can hide them by right-clicking on the object, selecting
"Properties", then checking the "Hidden" check-box. This won't work for SQL
Server objects (Tables/Views/SPs/Functions). Conceivably, MS could make it
work only in Access, but they never did.



Rob
 
Back
Top