Re: Can "Access 2007" Access Remote SQL-Server?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Brad,

Yes you can sdo that. On your control panel, there is a icon, Data Sources
(ODBC). Open it and click the System DNS tab. Click the Add button and go
through the Wizard. You will need the IP Address and login info for you
Database. Get that from your host provider. You will give it a name and
save it at some point.

In Acces click the External Data tab and the Import group select More. Then
ODBC Database. Click the Link to the data source... option. Click the
Machine Data source tab and you should see your new DNS name. Select it and
you will get a login screen to the database. After logging on, you will
get a table list. Select the tables to link and click OK.

The links will have a dbo_ prefix. You can rename the link and remove
that.

God Bless,

Mark A. Sam



"Brad" <Brad@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:734A24CB-DF77-4FC7-9A38-D96F30D68D6F@xxxxxxxxxxxxxxxx
Can "Access 2007" Access Remote SQL-Server?

Is it possible to access a Microsoft SQL-Server database that resides in
another firm's location? Our Website hosting is outsourced. A small
number
of SQL-Server tables are used to support this site. We want to access the
data in these tables via Access 2007 at our site.

Just recently we have set up a test system with Access 2007 getting at a
local SQL-Server database via ODBC. This works nicely. Now we would like
to
connect to the remote tables that support our Website. They are located
in
another state at the hosting firm's location. We would like to connect
over
the internet. There is no VPN.

If this connection is possible, where can I learn about how to set it up?

If getting at these remote SQL-Server tables is not possible with
Access-2007, are there good alternative approaches. Our budget is very
limited.

Thanks in advance for your help.
Brad



.

Quantcast