SQL connections to Access

• Simon AV

  SSCommitted

  Points: 1551

  More actions

  June 12, 2008 at 9:01 am

  #122603

  We have an old access database which someone is trying to connect to from a linked server in SQL2005. In SQL2000 this worked with no issue however I cannot now find a old db provider which will allow me to connect to this db.

  Is this possible anymore or does the fact that it is access 97 mean the connection is now not possible ?

• JamieX

  Hall of Fame

  Points: 3763

  More actions

  June 13, 2008 at 9:03 am

  #828590

  Sure this is possible.

  Take nwind.mdb in root of C drive for example

  Create new linked server in SSMS

  Linked Server = NWIND

  - Other Data Source Checked

  Provider = Microsoft Jet 4.0 OLE DB Provider

  Product Name = OLE DB Provider for Jet

  Data Source = c:wind.mdb

  Save it.

  Now can query:

  select *

  from [NWIND]...[Categories]