Can I access Access 2007 database via ole-DB?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vvenk - 17 Sep 2007 23:06 GMT

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.

Reply to this Message

SteveM - 18 Sep 2007 01:20 GMT

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

Steve

> Hello:
>
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message

vvenk - 19 Sep 2007 20:30 GMT

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

> Do a Google on 'oledb access 2007' and you will get lots of information about
> this including dowload pages for data providers.
[quoted text clipped - 13 lines]
> >
> > Thanks.

Reply to this Message