Remote tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JIM WHITAKER - 20 Aug 2005 17:52 GMT

I have been playing around with access 2000 and msde. My question is this:
If I find a company that host sql server databases, can the tables be in
Baton Rouge, LA and the Microsoft Access .ADP file be in Dallas, TX? In
other words, can you connect to remote ms sql tables that are really remote,
a long distance away? If so, what is required, and are there companies that
host sql server in order to avoid buying it?
Please give detailed answer, because I'm almost ready to set up my database
if I can.

Reply to this Message

Sylvain Lafontaine - 20 Aug 2005 19:56 GMT

The answer is yes if the port 1433 is not blocked by a firewall on either
the client side or the server side. Make sure that the host if offering a
full access to the SQL-Server, without blocking the port 1433 (or any other
necessary port if they are using dynamic configuration).

You can also become your own host, see www.no-ip.info for example.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

>I have been playing around with access 2000 and msde. My question is this:
> If I find a company that host sql server databases, can the tables be in
[quoted text clipped - 7 lines]
> database
> if I can.

Reply to this Message