2

How to create ODBC or DSN file for connection so that Access Linked Tables are pointing to hosted SQL Tables?

mawlsam
  • 21
  • 1

1 Answers1

1

As long as you can connect to the SQL Server using SQL Server Management Studio, you can use MS Access to connect as well

Start / Run "ODBCAD32.exe"

Create a DSN for that SQL Server with the appropriate information.

In MS Access, you can now create linked tables that use your new DSN.

Raj More
  • 47,048
  • 33
  • 131
  • 198
  • Connection failed: SQLState: '01000' SQL Server Error: 10061 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()). – mawlsam Sep 21 '10 at 22:00