ISAM errors

[TRYP]

i am trying to connect to an Access 97 database using ADO

I am getting this error message " -2147467259 Couldn't find installable ISAM."

I dont have a clue.


My Code:

Private Sub Command1_Click()
On Error GoTo errorhandler

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

Dim recs As ADODB.Recordset
Set recs = New ADODB.Recordset

conn.ConnectionString = "persist security info=true;" & "provider=microsoft.jet.oledb.3.51;" & _
"data source=c:\database.mdb;" & _
"pwd=password;" & _
"uid=user;"
conn.Open
recs.Open "select * from TABLE", conn

Exit Sub
errorhandler:
Text1 = Err.Number & " " & Err.Description
End Sub

any ideas guys & gals ?
-tryp

 

[edderic]

take a look at :

http://search.support.microsoft.com...s&CAT=Support&VRL=ENG&SA=MSDN&Go.x=39&Go.y=27

Eric

Eric De Decker
vbg.be@vbgroup.nl

Licence And Copy Protection AxtiveX

http://www.createsoftware2000.com