Linking Tables

  • Thread starter Thread starter Scott Duncan
  • Start date Start date
S

Scott Duncan

Is it possible to Link [External] Tables thru a Wide Area Network ???

If so, does anyone know which ports on the Router (TCP or UDP) need to be
opened for this to work...

Thank you in advance,

Scott Duncan
Deka Scale Incorporated
Toledo, Ohio USA
 
Hi Scott,

It is possible to link to external tables. The protocol used to
transfer data really determines the port number. Or you can
specify a port number when creating a TCP or UDP
connection.

You can use other port numbers when using the HTTP protocol,
by specifying a port number at the end of a URI.

Generally you'll place the port number at the end of a URI as
follows:

http://www.domainname.com:portnumber/pathtodata/

where:
domainname is the domain you wish to link to,
portnumber is the port the information will be going over (0 to 65535),
pathtodata represents the full path and filename to the data.

This http:// specifies that you'll use the the http protocol to transfer,
as opposed to telnet, nntp, smtp, etc.

The different protocols all have a default port number that they
operate over, http operates over port 80 by default, smtp goes
over port 25 by default, and so on.

Hope that helps.

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


:
Is it possible to Link [External] Tables thru a Wide Area Network ???

If so, does anyone know which ports on the Router (TCP or UDP) need to be
opened for this to work...

Thank you in advance,

Scott Duncan
Deka Scale Incorporated
Toledo, Ohio USA
 
Also, the word "link" is alittle ambiguous. Because there are
relationship links as well as physically creating a "linked" table
that is actually an attachment to another table. This "linked"
table is a direct connection to an external table whereby
linking tables as to create a relationship is a totally separate
concept.

Please post back and let us know if this helps at all.

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


:
Is it possible to Link [External] Tables thru a Wide Area Network ???

If so, does anyone know which ports on the Router (TCP or UDP) need to be
opened for this to work...

Thank you in advance,

Scott Duncan
Deka Scale Incorporated
Toledo, Ohio USA
 
Scott,

If you are linking to Access tables over a WAN, you are begging for a
corrupt database. WAN connections are way slower than LAN, and far less
stable. Both of these things really tick Access off.

While it may be possible, it is not advisable. If you can describe your
requirements a bit, there may be other options.

HTH,

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Back
Top