[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

How do I connect MS Access 2007 to MS SQL Server 2008 Databases?


I am trying to simply create table links from MS Access 2007 to my database tables in MS SQL Server 2008.  I can perform this task easily with MySQL's ODBC Package, but I can't seem to find any ODBC drivers for MS SQL Server.  Is there another way to connect to the sever other then ODBC or do you know of any free ODBC's out there that can help me perform the simple task of creating table links?

Thank you very much in advance!!!!!!!
2 Solutions
You will need the MDAC for SQL Server to connect via ODBC or ADODB.  

You can link the tables or make an ADODB Connection them load the tables as required in an ADODB recordset.
stracqanAuthor Commented:

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now