Unreconized data format

[faa2006]

Member since: November 04, 2006
Total points: 82 (Level 1)
Points earned this week:
--% Best answer

faa
S Hey,guys am trying to use my Access 2000 database with Visual basic program. says ,!unrecognised data Format!
where do i change the code
?
How do i use microsoft jet 4.0 or ado 3.6 instead of using the 3.51 version

Private Sub Form_Load()
Dim X As Integer
CenterForm Me
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=MSDataShape;Data PROVIDER=Microsoft.Jet.OLEDB.3... Source=" & App.Path & "\db4.mdb;"
Set Adologin = New Recordset
Adologin.Open "select User,password,files,transactio... from users Order by User", db, adOpenStatic, adLockOptimistic
 
For X = 1 To Adologin.RecordCount
txtUserid.AddItem Adologin.Fields("User")
Adologin.MoveNext
Next X
txtUserid.ListIndex = 0
End Sub