Remote connection to Access

[Aidan]

Our organization uses IIS6 virtual directories for remote access to the
server file system. We also use a frewall and would like to leave as little
exposure as possible. When we connect via the Internet to the virtual
directory, we can launch the Access 2003 database on our remote computer but
it is really a copy of the database on the server at the office. Some users
in the office update the database at the same time as the remote users need
to update it. Is there a way to connect to the Access databas over the
Internet throgh a firewall and update it interactively as though we were
locally connected to the LAN? Thanks for your help.

[Tom van Stiphout]

On Fri, 03 Dec 2004 22:47:17 GMT, "Aidan" <or***********@hotmail.com>
wrote:

No.
Unless you use a tool like Remote Desktop aka Terminal Services.

-Tom.

Our organization uses IIS6 virtual directories for remote access to the
server file system. We also use a frewall and would like to leave as little
exposure as possible. When we connect via the Internet to the virtual
directory, we can launch the Access 2003 database on our remote computer but
it is really a copy of the database on the server at the office. Some users
in the office update the database at the same time as the remote users need
to update it. Is there a way to connect to the Access databas over the
Internet throgh a firewall and update it interactively as though we were
locally connected to the LAN? Thanks for your help.

[Tim Mills-Groninger]

"Aidan" <or***********@hotmail.com> wrote in message
news:V16sd.30$jY1.11@trnddc07...

Our organization uses IIS6 virtual directories for remote access to the
server file system. We also use a frewall and would like to leave as
little
exposure as possible. When we connect via the Internet to the virtual
directory, we can launch the Access 2003 database on our remote computer
but
it is really a copy of the database on the server at the office. Some
users
in the office update the database at the same time as the remote users
need
to update it. Is there a way to connect to the Access databas over the
Internet throgh a firewall and update it interactively as though we were
locally connected to the LAN? Thanks for your help.

You can connect via the Windows server VPN - free and somewhat secure - this
makes you a node on the network.

I'm constantly amazed at how effective this is with a split databse and
connection speeds below the recommend 10mbs.

I've also been told of a ODBC connection via port 2433 or somesuch, but I'm
not at all sure of the details.

hth,

Tim Mills-Groninger

[Tom van Stiphout]

On Fri, 03 Dec 2004 23:14:25 -0700, Tom van Stiphout
<no*************@cox.net> wrote:

Sorry, I was a bit too quick. The VPN route is indeed another option.
Just don't try anything over HTTP or FTP.

-Tom.

On Fri, 03 Dec 2004 22:47:17 GMT, "Aidan" <or***********@hotmail.com>
wrote:

No.
Unless you use a tool like Remote Desktop aka Terminal Services.

-Tom.

Our organization uses IIS6 virtual directories for remote access to the
server file system. We also use a frewall and would like to leave as little
exposure as possible. When we connect via the Internet to the virtual
directory, we can launch the Access 2003 database on our remote computer but
it is really a copy of the database on the server at the office. Some users
in the office update the database at the same time as the remote users need
to update it. Is there a way to connect to the Access databas over the
Internet throgh a firewall and update it interactively as though we were
locally connected to the LAN? Thanks for your help.

[Aidan]

Thanks for the suggestions. I originally tried a NetGear VPN appliance but
was unable to get it to work. I have installed MS-IAS Server in the past and
had good luck with it but this client doesn't want to spend the money at
this time. RDP,VNC and PCAnywhere are already in use on other computers in
the office. They have very linited resources and can't really afford to get
another computer for the office - no space either. I guess that since HTTP
won't do it for them, they're out of luck until they get the money together
for IAS :-). Thanks again for your help with this, I truly appreciate
it - Aidan

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:r5********************************@4ax.com...

On Fri, 03 Dec 2004 23:14:25 -0700, Tom van Stiphout
<no*************@cox.net> wrote:

Sorry, I was a bit too quick. The VPN route is indeed another option.
Just don't try anything over HTTP or FTP.

-Tom.

On Fri, 03 Dec 2004 22:47:17 GMT, "Aidan" <or***********@hotmail.com>
wrote:

No.
Unless you use a tool like Remote Desktop aka Terminal Services.

-Tom.

Our organization uses IIS6 virtual directories for remote access to the
server file system. We also use a frewall and would like to leave as littleexposure as possible. When we connect via the Internet to the virtual
directory, we can launch the Access 2003 database on our remote computer butit is really a copy of the database on the server at the office. Some usersin the office update the database at the same time as the remote users needto update it. Is there a way to connect to the Access databas over the
Internet throgh a firewall and update it interactively as though we were
locally connected to the LAN? Thanks for your help.