none
SQL Server Compact Edition & MS Access 2002 RRS feed

  • Question

  • Several questions actually:

    1) Will MS Access 2002 work with SQL Server Compact Edition 3.5 ?
    2) Will MS Access 2002 work with SQL Server Express 2008 ?
    4) Can both SQL Server Compact Edition 3.5 and SQL Server Express 2008 reside together on the same computer? 

    Monday, November 9, 2009 12:28 PM

Answers

  • Several questions actually:

    1) Will MS Access 2002 work with SQL Server Compact Edition 3.5 ?
    2) Will MS Access 2002 work with SQL Server Express 2008 ?
    4) Can both SQL Server Compact Edition 3.5 and SQL Server Express 2008 reside together on the same computer? 


    1) Yes.
    2) Yes.
    3) Yes.

    For Access to connect to the newer SQL servers you'll probably have to install SNAC and use a DSN.

    Go here for more info:
    http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx
    Wednesday, November 11, 2009 5:52 AM