469,584 Members | 2,440 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,584 developers. It's quick & easy.

Remote connection to Access

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.
Nov 13 '05 #1
4 2002
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.


Nov 13 '05 #2

"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
Nov 13 '05 #3
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.


Nov 13 '05 #4
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.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Mike MacSween | last post: by
3 posts views Thread by Hrvoje Vrbanc | last post: by
1 post views Thread by Chris | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.