ADO error "could not find installable ISAM"

  • Thread starter Thread starter Accessor
  • Start date Start date
A

Accessor

Hi all. I'm trying to use some ADO via VBA in my database, and I'm running up
against the error "could not find installable ISAM." It's frustrating since I
have the same connect string except for the file name in excel vba for
another database. I just set up the ADO reference, 2.8. Any suggestions?
Here's my connect string:

strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Souce=C:\Documents
and Settings\User\Desktop\BusinessActive\Estimator 9-28-09.accdb"

Thanks in advance.

Kevin
 
Are you trying to use this code inside the same database that you are
connecting to? if so, just use the

CurrentProject.Connection

and don't attempt to use an outside reference as it will blow up on you.
 
Bob Larson said:
Are you trying to use this code inside the same database that you are
connecting to? if so, just use the

CurrentProject.Connection

and don't attempt to use an outside reference as it will blow up on you.
Click to expand...
 
Back
Top