Connection string for Access 2010

Question

I want to connect to the access 2010 database from excel.I am using VBA.I wrote the connection string as

Public objCon As New ADODB.Connection

objCon.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & ActiveWorkbook.Path & _
            "\asset_database.accdb;ACE OLEDB:Database Password=password;"

But it is giving the error "could not find installable ISAM".What is this error?

Answer 1

Oddly enough, it is Jet OLEDB Password, not ACE:

objCon.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & ActiveWorkbook.Path _
   & "\asset_database.accdb;Jet OLEDB:Database Password=password;"

See: http://www.connectionstrings.com/access-2007