Remote tables

[JIM WHITAKER]

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.

 

[Sylvain Lafontaine]

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.