mawlsam
Reputation: 21
How to connect MS Access to hosted SQL database?
How to create ODBC or DSN file for connection so that Access Linked Tables are pointing to hosted SQL Tables?
Upvotes: 2
Views: 343
Answers (1)
Raj More
Reputation: 48058
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.
Upvotes: 1
Related Questions
- How to connect Ms access 2010 (.accdb ) database with odbc driver
- Connecting MS Access to SQL Server on a network
- Connect to an Access database with ODBC via ASP.net
- Need to remotely create an ODBC connection to a SQl server
- ODBC connection to MS-Access on Ubuntu
- SQL-Server Backend, MS Access Frontend: Connection
- How do you link a sql server to Microsoft Access?
- How to create a ODBC connection to SQL Server?
- How to connect to a MS SQL database using MS Server Management Studio and ODBC
- Create ODBC Connection from Access to SQL Server