Public Sub ADOOpenDatabase()
Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\db1.mdb;Persist Security Info=False;Exclusive=0"
I get the following error:
-2147467259 (80004005) Cannot find installable ISAM
I have Microsoft Access 9.0 Library, ActiveX Dataobjects 2.8 Library, Microsoft DAO 3.6 Object library and , ADO Extension 2.8 Library referenced.
Can someone help with what needs to be loaded?
My help files on ADO are not working. Is there somewhere where I can download it from?