ADO connection error

J

John T Ingato

I am attempting my first attempt to connect to an Access database using ADO.
When I try to open the connection I get a run-time error -2147467259
(80004005) Could not find installable ISAM.

what the heck does this mean?
I have a book Excel 2003 VBA and followed the code to the T. Am I missin
something?


Sub init()

Dim Connection As ADODB.Connection
Set Connection = New ADODB.Connection
Connection.ConnectionString = ConnectionString

Connection.Open
MsgBox Connection.State = ObjectStateEnum.adStateOpen
Connection.Close


End Sub
 
A

Alok

Hi,
There is probably something wrong with the connection string. Insert a line
before Connection.Open (Assuming the this is the line that is raising the
error)

Debug.Print Connection.ConnectionString

Then examine the ConnectionString that is printed - see if you can find a
problem with it. Let the newsgroup know and someone may be able to help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top