ADO to Access 2000

[k3nnan]

How can I get data from Access 2000 with ADO here is my code but I get error "Unreconized database format", this code is working with Access 97.

Private Sub Form_Load()
Adodc1.ConnectionString = "provider=microsoft.jet.oledb.3.51;" & "persist security info=false;" & "data source=c:\caset.mdb"

Adodc1.RecordSource = "select*from 21Temp"
Set Combo1.DataSource = Adodc1
Combo1.DataField = "hej"
End Sub

[Cakkie]

Access 2000 needs Jet 4.0+, so you should change the connectionstring to use 4.0, not 3.51

Tom Cannaerts
slisse@planetinternet.be

Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook