Access table link to SQL question

I have a SQL 7 database I want to link to from Access 2000. Previously this
database could be linked to over our local network by way of a WAN link. We'
ve just moved and now that WAN link has been severed and so I'm forced to re
establish the table link ov
er the internet. The SQL server and website exist on the same box and when I
enter the public IP address of the server into the input field labeled "wha
t server do you want to connect to?" in DSN setup, it won't accept it. What
do I have to do to establis
h a dsn to a database over the internet as opposed to a local network?One option would be to add an entry to your host file for
the server and it's IP address. Then configure the DSN with
the server name you put in the host file for the server.
-Sue
On Thu, 18 Mar 2004 07:46:05 -0800, "Glenn"
<gvenzke@.equiguard.com> wrote:

>I have a SQL 7 database I want to link to from Access 2000.
>Previously this database could be linked to over our local network
>by way of a WAN link. We've just moved and now that WAN link
>has been severed and so I'm forced to reestablish the table link
>over the internet. The SQL server and website exist on the same
>box and when I enter the public IP address of the server into the
>input field labeled "what server do you want to connect to?" in DSN
>setup, it won't accept it. What do I have to do to establish a dsn to a
>database over the internet as opposed to a local network?