Connect Access 2007 to SQL Server 2008 Database

Posted by Peter on Stack Overflow See other posts from Stack Overflow or by Peter
Published on 2009-03-11T16:01:22Z Indexed on 2010/04/10 21:23 UTC
Read the original article Hit count: 509

Hi, I've seen numerous answers to similar questions like this one. I haven't seen on the web many people have asked the seemingly simple question "How do I connect Access 2007 to an SQL server 2008 database" - but all of the answers describe how you can migrate from access 2007 to an sql server 2008 database, or they describe how to connect access 2007 to an sql server 2005 database. I can't find any simple solution to my problem (and probably this is a problem for many others). Here is the question (sorry for the over emphasis):

How do I connect to an sql server 2008 database (and I mean 2008, not 2005 :) ) from access 2007? Apologies again for the over emphasis, but this very simple question, and what I thought should be a very simple task seems, yes, ... impossible! I tried running sql server browser, enabling pipes, TCP etc, but it seems that with 2008 SQLEXPRESS just isn't recognised! Please can someone help with this. Peter

© Stack Overflow or respective owner

Related posts about ms-access

Related posts about ms-access-2007