connect to Access 2010

[#1]

anyone know how to connect to Access 2010?

I can only connect to *.mdb files not *.accdb.

[#2]

Hi,

Try to use ODBC Data Source Administrator. You must create system DSN with your database. Then in the edit script dialog, you must connect to system data source.

I think it helps you.

Regards, Bill

[adhudson]

Hi,

     The *.accdb files are being used in different formats, the Provider to link with the database also changes.

     You can see the provider name in the connection string.

     You have to use Microsoft.ACE.OLEDB.12.0 provider to connect to the .accdb files.

     This provider will only be available if you have installed MS Office 2007 or above.

     Please find the attached sample qvw file.

Regards

Andrew Hudson