Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #10012

Re: OT: WMI Events hint needed

Show all headers | View raw

<CDMAPoster@fortunejames.com> wrote in message 
news:3e54febc-857f-42ee-8214-b16274c5192c@googlegroups.com...
> I wrote a small database to set special permissions for certain 
> directories.  The users tried creating a "template" directory on the 
> network drive with the correct permissions, but when copied to a new 
> directory, the OS adds additional users and deletes others.  At first, I 
> had Access create a script file to be run on the server to find and set 
> all the directory permissions appropriately.  But when a new directory is 
> created, the users are faced with the same problem.  I found that the 
> people in charge of setting the file permissions, and who have the right 
> to change permissions for the new directory, have the icacls.exe program 
> on their computers.  I created a form with a command button to select the 
> directory to protect (or they can paste the directory name into a 
> textbox).  Then when they hit a command button, the icacls commands are 
> executed and the directory is set to the desired permissions for two 
> groups of users.  The users complained that even doing that was too much 
> work, so I starting looking at WMI Events with the hope that the server 
> can detect when a directory is created or copied to a certain subdirectory 
> on a single network drive and check the name of the folder created to see 
> if a script should be run on it to set permissions.  The company will 
> provide me with an Administrator account password on the server at least 
> until I set up such an event trigger.  My main sources of information are:
>
> http://msdn.microsoft.com/en-us/library/aa392727(v=vs.85).aspx#_hmm_file_system
>
> and
>
> http://technet.microsoft.com/en-us/library/hh457545.aspx
>
> I don't generally write server scripts, so the WMI Events are new to me. 
> Alternatively, is there some kind of ACL permissions file that can be 
> imported right after the directory is created?  Note: editing the Security 
> tab is also considered to be too much effort by the users.  An event 
> driven solution on the server seems to me to be the best option.  A 
> PowerShell script is O.K. if it also does the event monitoring.  Also, the 
> server (Windows Server 2008 R2) runs Active Directory.  Has anyone here 
> done anything like monitoring a network drive like that before?
>
> Thanks in advance,
>
> James A. Fortune
> CDMAPoster@FortuneJames.com

Access can setup WMI events using the "Microsoft WMI Scripting V1.2 Library" 
in a Class Module. I Have one that watches for wireless and VPN network 
connections on the users workstation. Some searching may find you a WMI 
query to monitor a folder. But, I would think it would need to run on the 
server. 

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

OT: WMI Events hint needed CDMAPoster@fortunejames.com - 2014-10-08 12:33 -0700
  Re: OT: WMI Events hint needed "Ron Paii" <None@none.com> - 2014-10-09 07:48 -0500
    Re: OT: WMI Events hint needed CDMAPoster@fortunejames.com - 2014-10-09 12:03 -0700
      Re: OT: WMI Events hint needed "Ron Paii" <None@none.com> - 2014-10-09 16:20 -0500
        Re: OT: WMI Events hint needed CDMAPoster@fortunejames.com - 2014-10-09 14:41 -0700
          Re: OT: WMI Events hint needed Ulrich Möller <knobbi38@arcor.de> - 2014-10-10 00:04 +0200
            Re: OT: WMI Events hint needed CDMAPoster@fortunejames.com - 2014-10-10 09:49 -0700

csiph-web