ACCESS over TCP/IP

  • Thread starter Thread starter Nuno Fonseca
  • Start date Start date
Actually, those who say you cannot connect to an Access DB via TCP/IP are
correct. In your scenario you are not connecting to the database at all. You
are using TCP/IP as the protocol to connect to the file system of the remote
computer using the IP address rather than the more usual DNS name or NetBIOS
name (or even mapped drive). You seem to be confusing file sharing using the
IP address as identifier with a socket server connection to a database
engine using the TCP/IP protocols.

Access databases are file based which means that the local (in process) Jet
database engine manipulates the contents of the database via a file handle
to whatever file you have identified in your connection string. Your TCP/IP
connection simply returns a pseudo-handle to the remote file system which is
accessed as though it was local to return the appropriate results.

In a client/server based DBMS on the other hand you connect directly to the
database engine on the server via TCP/IP and the database server does all
the manipulation before returning the results.

Some of the confusion may be caused by the unfortunate use of the word
connection. You never literally connect to a database but rather to the
database engine which in turn accesses the file system (or whatever physical
store your DBMS uses) and RAM to retrieve/manipulate the data in the
database.

Also, your option 2 is the only viable one over the Internet since if you
are exposing file system sharing directly to the public Internet you should
probably be fired ASAP.
 
Stephen,

Of course the question was "Is it possible?" I gave 3 ways to make it
"possible" not "practical" or "safe". Of course the VPN tunnel is the way I
would prefer to do it. I think that if we fired people for creating network
places to shares which have their security access on them we would have to
fire a lot of people.

Regards
 
Hi,
I know for sure that SocketPro at www.udaparts.com will work for you.
See the sample TestSocketProWithVBNet inside the package. Why don't you give
it a try?

--
Yuancai (Charlie) Ye
RDB, a tool for fast and securely accessing remote databases with dial-up,
cable, DSL and wireless modems anywhere

Fast and securely accessing all of remote data sources anywhere with
SocketPro using batch/queue, non-blocking and parallel computation

See 30 well-tested and real OLEDB examples
www.udaparts.com
 
Back
Top