[AccessD] Hiding objects programmatically

Wow, thanks for the warning.  I vaguely remember this but never really used the hidden property before.

I guess I will set by hand.  Do we think this only apples to tables or every database object?

John W. Colby
www.ColbyConsulting.com

On 9/1/2011 12:55 PM, Heenan, Lambert 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
>