I am connecting an access mdb format and cannot display the values from the database table onto a form in vb . I need also to enter values to the same database. I appreciate any help anyone can provide as I am new to all this. I did the same exercise as from http://www.homeandlearn.co.uk/NET/nets12p4.html
but did not help a lot.
GeorgeFarr
0
Newbie Poster
Recommended Answers
Jump to Postwhat version of MS Access you are using?
All 3 Replies
c0deFr3aK
1
Junior Poster in Training
what version of MS Access you are using?
GeorgeFarr
0
Newbie Poster
what version of MS Access you are using?
Access 2007 in windows vista and in saved as mdb format
Thank you
c0deFr3aK
1
Junior Poster in Training
Access 2007 in windows vista and in saved as mdb format
Thank you
that's not correct extention. The MS Access 2007 has .accdb extention.
Example, you created a database using Access 2007 "myDataBase.accdb"
So in your connection string it should looked like:
Dim conn As New Oledb.OledbConnection("Provider=Microsoft.Ace.OLEDB.12.0;Datasource=myDataBase;Persist Security Info=False")
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.