|
-
Jul 27th, 2007, 09:37 AM
#1
Thread Starter
New Member
Unreconized data format
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
-
Jul 27th, 2007, 10:04 AM
#2
Re: Unreconized data format
Change the Provider argument of the connection string.
Data PROVIDER=Microsoft.Jet.OLEDB.4.0;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|