Can I access Access 2007 database via ole-DB?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

I am using Access 2007.

I am trying to access an Access 2007 from within Microsoft SQL Server
Business Inteligence Studio.

I do not see a Ole-DB driver that supports Access 2007. If i use OLE-DB
driver for Microsoft Jet 4.0 Engine, the file extension defaults to MDB and
even if I cahnge it to *.accdb, I get errors.

Thanks.
 
Do a Google on 'oledb access 2007' and you will get lots of information about
this including dowload pages for data providers.

Steve
 
Steve:

I did find a Ole-DB driver for Access 12 (aka Access 2007) already
installed. Once I used that driver, I was able to access the DB.

Thanks.

venki
 
Back
Top