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?

Fionnuala · Accepted Answer · 2011-08-22 07:25:11Z

7

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

answered Aug 22, 2011 at 7:25

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Banjoe · Accepted Answer · 2011-08-22 07:28:00Z

2

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

answered Aug 22, 2011 at 7:28

Banjoe

1,76812 silver badges13 bronze badges

Comments

sigil · Accepted Answer · 2011-08-22 23:40:47Z

-1

If you have Access installed, or you install the Access Database Engine on the workstation that has the Excel spreadsheet open, then you don't need to create an OLEDB connection; you can just open a database object as follows:

dim db as database

set db=opendatabase("c:\db path\my db.accdb")

answered Aug 22, 2011 at 23:40

sigil

9,62244 gold badges129 silver badges217 bronze badges

Collectives™ on Stack Overflow

Connection string for Access 2010

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related