2

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

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Connection failed: SQLState: '01000' SQL Server Error: 10061 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.