By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

is vpn the only way to use access across the internet

P: n/a
is there no other way to use access(.mdb) across the internet?? (than vpn or
worse yet terminal services)
i'm trying to write to a mdb on my organization win2k server from my
webhost redhat webserver with perl. then i have an 'inside' application
that will connect to the same db with a vb program across the lan, this part
is no problem

vpn is theoretically possible but not realistic in my situation

is it much simpler if the sql server was the db and then when i need that
data inside my lan, i can link access to the sql server tables via odbc so i
have the ms access
functionality and ease of use with sql server really collecting the data
from the website/perl

is vpn the only way to use access across the internet
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Yes, a vpn is the only way. Remember, using JET requites that you SEE the
file. Remember, you do NOT have to install jet where the file resides (ie on
the server). JET is running on YOUR END, and thus it simply needs to "see"
the file on the other end. The only way to share files across the net is to
use a vpn. JET cannot accept a socket connection since JET runs on YOUR end.
With a server based system like sql-server, you have the exact oppose setup,
where the "engine" runs on the server, and you connect to it. With a JET
file share, JET runs on your computer and OPENS the file on the other end.
Since JET needs to "open" the file, then JET has to be able to see the file
like any other regular file (exactly the same as word, or excel). You can't
use word across the internet either. There is nothing special about a mdb
file. It is just a regular file that windows wants to open. So, if you can
open the file remotely, then you can use it. Hence, that regular file can be
on your hard disk, or a network share, but for purposes, JET just thinks it
is a file, and want to open it. With sql server, you don't open the file on
the other end, but connect to some "engine" (some software running) that
accepts commands.

As mentioned, you don't install JET or anything where the file resides.

You can certainly setup some asp web pages that connects via JET to a mdb
file sitting on the server. It would then be the web server that is
accepting commands, and sending them to the JET file share on the same web
server. Of course, using asp pages with a web server does allow you to
connect to a JET mdb file share...but you are using ms-access anymore when
you do this (you are using JET...and a web server can connect to JET).
i can link access to the sql server tables via odbc so i
have the ms access
functionality and ease of use with sql server really collecting the data
from the website/perl


Yes, the above is correct. Further, if you make a web only application, then
as mentioned, you can use JET on the web server and not have to use
sql-server (but no ms-access front end can connect to that). You can however
certainly migrate your data out of the JET file share and into sql server.
You then can still thus keep your front end part in ms-access, and connect
to the server via ODBC. In that case, you can connect across the internet to
the database on the server with ms-access front end (and your users on the
LAN can also connect this way). Thus, when connecting to a sql database from
ms-access using ODBC, then you don't have actually see the files, and a
simple IP address will allow a socket connection.

This allows your ms-access application to function anywhere in the world and
connect to the server.

You can read my thoughts on using a VPN and ms-access at:

Using a wan with ms-access? How fast, how far?
http://www.attcanada.net/~kallal.msn/Wan/Wans.html

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn

Nov 12 '05 #2

P: n/a
thanks a lot for this detailed clarifiication
"Albert D. Kallal" <ka****@msn.com> wrote in message
news:bcRgb.45619$9l5.15233@pd7tw2no...
Yes, a vpn is the only way. Remember, using JET requites that you SEE the
file. Remember, you do NOT have to install jet where the file resides (ie on the server). JET is running on YOUR END, and thus it simply needs to "see"
the file on the other end. The only way to share files across the net is to use a vpn. JET cannot accept a socket connection since JET runs on YOUR end. With a server based system like sql-server, you have the exact oppose setup, where the "engine" runs on the server, and you connect to it. With a JET
file share, JET runs on your computer and OPENS the file on the other end.
Since JET needs to "open" the file, then JET has to be able to see the file like any other regular file (exactly the same as word, or excel). You can't use word across the internet either. There is nothing special about a mdb
file. It is just a regular file that windows wants to open. So, if you can
open the file remotely, then you can use it. Hence, that regular file can be on your hard disk, or a network share, but for purposes, JET just thinks it is a file, and want to open it. With sql server, you don't open the file on the other end, but connect to some "engine" (some software running) that
accepts commands.

As mentioned, you don't install JET or anything where the file resides.

You can certainly setup some asp web pages that connects via JET to a mdb
file sitting on the server. It would then be the web server that is
accepting commands, and sending them to the JET file share on the same web
server. Of course, using asp pages with a web server does allow you to
connect to a JET mdb file share...but you are using ms-access anymore when
you do this (you are using JET...and a web server can connect to JET).
i can link access to the sql server tables via odbc so i
have the ms access
functionality and ease of use with sql server really collecting the data
from the website/perl
Yes, the above is correct. Further, if you make a web only application,

then as mentioned, you can use JET on the web server and not have to use
sql-server (but no ms-access front end can connect to that). You can however certainly migrate your data out of the JET file share and into sql server.
You then can still thus keep your front end part in ms-access, and connect
to the server via ODBC. In that case, you can connect across the internet to the database on the server with ms-access front end (and your users on the
LAN can also connect this way). Thus, when connecting to a sql database from ms-access using ODBC, then you don't have actually see the files, and a
simple IP address will allow a socket connection.

This allows your ms-access application to function anywhere in the world and connect to the server.

You can read my thoughts on using a VPN and ms-access at:

Using a wan with ms-access? How fast, how far?
http://www.attcanada.net/~kallal.msn/Wan/Wans.html

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.