[AccessD] OT: Make shares available over the internet

John, take a look at ACL, Access Control List.  They use the credentials
of the machines logged onto the network.  But then again this could be a
security issue because if one machine gets hacked then all machines using
an ACL are vulnerable.

Mike

> As I mentioned, I am doing quite a bit of Access FE linked over the
> internet to SQL Server.  I use
> Hamachi to create VPNs which are private, i.e. you have to be invited to
> join.  Once I OK your join
> then you can "see" the server and the SQL Server instance.  Hamachi has a
> Browse function which
> allows browsing shares on the remote machine, and SQL Server answers up at
> the IP address so that works.
>
> I am trying to invent a way to allow running a batch file on the user
> workstation which would pull
> the FE and the frameworks over the internet from my server to the
> workstation.  ATM getting new
> versions installed is a "I do it" thing.  This is unworkable in the long
> term so I have to find an
> automation method.
>
> My biggest issue is security.  The VPN is private of course, however I
> have several different
> networks all connecting to the same server.  In order to have security
> between the networks I have
> to have some kind of username / password for each network which has rights
> to a shared directory.
> At the workstation end, that username has to be used to get at the share
> which it then has rights
> to.  The problem I am running into is that while that works, the end user
> has to know / remember /
> use the password when the shared folder is accessed.  I am not finding a
> way to allow the batch file
> which I would use to download specific files to pass the password to
> hamachi or whatever is asking
> for the password.
>
> Am I making any sense here?
>
> Five different Hamachi networks.  Each network has its own username /
> password able to access its
> own shared directory.  Each workstation has to "know" about its username /
> password in order to
> access the share over Hamachi.  Much too much to expect of every user.
>
> I'm not sure where to go with this.
>
> --
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>