-
ADO to Access 2000
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
-
Re: ADO to Access 2000
Access 2000 needs Jet 4.0+, so you should change the connectionstring to use 4.0, not 3.51
Tom Cannaerts
[email protected]
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