[AccessD] Hiding objects programmatically

Charlotte Foust charlotte.foust at gmail.com
Thu Sep 1 12:01:23 CDT 2011


As I recall, the dbHiddenObject flag was used internally when you "deleted"
a table.  I got bitten by this back in A2k, IIRC.

Charlotte Foust

On Thu, Sep 1, 2011 at 9:55 AM, Heenan, Lambert <
Lambert.Heenan at chartisinsurance.com> wrote:

> Heads Up John,
>
> I don't know if this bug has been fixed but check this out...
>
> http://access.mvps.org/access/bugs/bugs0036.htm
>
>
>
> Lambert
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Thursday, September 01, 2011 10:25 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Hiding objects programmatically
>
> For production databases I like to hide all the objects in the design
> window by setting the property to hidden.  In the properties window (Tools /
> options / View) I then uncheck Hidden Objects and System Objects.  This just
> adds another level of obsfucation to the database for the average user.
>
> I did this and everything was copacetic.  And then... I run one (several
> actually) of my databases under 2007 runtime and this database was giving me
> that crash I discussed awhile back.  I ended up having to import everything
> into a new database and in doing so the hidden attribute of everything was
> set to visible.
>
> I don't have any code to set that property true / false for every object so
> I thought I'd ask before I go write one.
>
> So, does anyone have code to set the Hidden property of the database
> objects (tables, forms etc)?
>
> --
> John W. Colby
> www.ColbyConsulting.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>



More information about the AccessD mailing list