[AccessD] Access Lockdown

John,

You could try this technique - you can work another FE from your FE.
However, the properties you are changing don't take effect until the next
time the mdb file opened.  So a test is needed to see if this actually works
the next time the other FE is opened.  

  '-- Set Destination MDB as the CurrentDatabase
    Set MappDestination = New Access.Application
    MappDestination.OpenCurrentDatabase MstgDestinationFilePath
    DoEvents

Post back your results!  I use these properties also for each of my
customer's systems.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Saturday, May 21, 2011 11:50 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Lockdown

Gustav,

 > Having a senior moment? You did that yourself(!):

LOL.  Yea I went out and found that.  This is the basis (as is the code from
the other posters) but I really want an application that sets the properties
and then copies from / to.

My application allows you to open an Access FE, navigate to another Access
FE and set the properties there.  It is an entire user interface around this
code.

I am going to be modifying my app (designed in 10/2001 BTW) to add this
additional functionality.  I am going to need it table driven so that I can
select a group of files, set the properties and copy all of the files to
production.  As you know I also have two libraries to secure.

John W. Colby
www.ColbyConsulting.com

On 5/21/2011 10:52 AM, Gustav Brock wrote:
> Hi John
>
> Having a senior moment? You did that yourself(!):
>
>>>> 1999-05-18 08:15
> Subject: My FramwWIZ
> <snip>
> 3)    Page 2 of C2DbFrameWiz (as activated by Tools / addins /
C2DbFrameWiz)
> is a "wizard" to allow you to see and modify the built in properties 
> of the current database or any database (depending on button pushed).
>
> The "current database" button directly opens a form that displays all 
> the built in properties - StartupForm, StartupShowDBWindow, 
> StartupShowStatusBar, AllowBuiltinToolbars, AllowFullMenus, 
> AllowBreakIntoCode, AllowSpecialKeys, AllowBypassKey.
>
> These properties are read out of the database (current in this case) 
> and into a radio button for each property (bemoaned by Mr. Breen 
> because it really should be a check box) to allow you to select the 
> state you wish to set the property to (set or reset).  There is then a 
> button that you can press to save any changes to the properties back 
> into the database.  These properties allow the developer to "secure" 
> the operation of the database to prevent fiddling by the user.
> </snip>
>
> /gustav
>
>
>>>> jwcolby at colbyconsulting.com 21-05-2011 14:41>>>
> I want to lock down an application as I copy it from my dev directory 
> to a "live" directory.  I want to set the "display system objects and 
> "display hidden objects" properties in Options as well as Startup "Allow
full menus", Use Special Keys" etc.
>
> Has anyone got a utility that sets these properties?
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com