I am a total amateur to VB and Access...so pls help me to connect vb and access. I need step bt step instructions.
I just want to learn the basic so that i can do better applications next time. i want to have only one field : 'name' in MS Access !
So pls help me
How to connect vb 6.0 and access?
Hot Topic
- XML Comments
- How to build a VB program that run in other PC?
- surpressing the "Printing page 1 of Document" message
- Change filename when new year
- pc to rs232 to dsp
- Vertical line at col 80
- Running a function in another form
- encoding issue in vb.net
- Selected Value in ComboBox Populates DataGridView
- Progress Bar with unknown maximum value
How to connect vb 6.0 and access?
bbusacker
you need to specify the exact name of the database you have created to be connected on your program.
NMM
i get an error in this line
cn.Open ""Provider=Microsoft.Jet.OLEDB.4.0;;data source='" & App.Path & "\Nwind.mdb'"
i changed the NWIND.mdb to arvin.mdb
where i created a field called " name" and table name is " arvin "
hte
Try this...
Dim cn As New ADODB.Connection
Dim rec As New ADODB.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;data source=" & App.Path & "\Nwind.mdb'"
rec.Open "Employees", cn, adOpenDynamic, adLockOptimistic
Do While Not rec.EOF
List1.AddItem rec.Fields("FirstName").Value
rec.MoveNext
Loop
Rec.close
Set rec = Nothing
colonel
VB6 questions should be posted here:
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx dg=microsoft.public.vb.database&cat=en_us_a0845303-5e9e-4655-96d5-238b82a6b329&lang=en&cr=us