By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,661 Members | 781 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,661 IT Pros & Developers. It's quick & easy.

How to Connect my MS Access to the remote SQL Server??

P: 1
Dears, I am trying to create a type of smiple reporting tool using my MS Access. But I want my MS Access to read from the SQL Server that I have on the remote server.

Kindly give me some idea how to do that. Or if there are other options to create reports reading from remote SQL server kindly let me know.

Thanks
Feb 4 '15 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
One way to do so is to connect to the SQL Server tables using an ODBC driver. SQL Server drivers are part of the standard set available in the ODBC data source administrator for Windows.

Before you can connect Access to your SQL Server tables you need to set up a suitable ODBC connection using the ODBC data source administrator. When you have done that you can link Access to your SQL Server tables via the newly-created ODBC DSN connection. Once you have linked Access to the tables in SQL Server you can create queries, reports and so on as needed.

-Stewart
Feb 4 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.