Couldn't find installable ISAM

[shultz]

When I connect to the Access Database through VB and try to access the records, it gives me the error :

Run-time error '-2147467259 (80004005)'

Couldn't find installable ISAM

What could be the problem. I am running Access 97 on Win2K.

' *****************************
' The code is as follows
' *****************************

Dim accessConn As New ADODB.Connection
Dim accessRs As New ADODB.Recordset
Dim accSql as String

' --- The Connection string for connecting to the Access Database
accConnStr = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=D:\PostgreSQL\Data\GPRSSub.mdb"

' --- Get connected to the database
accessConn.Open accConnStr

accSql = "Select Date, GPRS_Sub from MonthlySub"
accessRs.Open accSql, accessConn

 

[CCLINT]

Could be one of two things: Your ConnectionString is wrong or you need to make sure you have loaded the MDAC_Typ 2.5 (download from

http://www.microsoft.com/data/),

as there was a problem with version 2.1.
Try letting the wizard set you up a Data Form and check the connection string it uses (PROJECT|ADD FORM| VB Data Form)

(please note: because you are using Jet 3.51 you will need to down load MDAC 2.5 and not any ones higher in order to get the correct Jet Dlls)

This is how I write it:
"Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;User ID=Admin;Data Source=D:\PostgreSQL\Data\GPRSSub.mdb"