VB.NET Tutorial - Connect & Query a Microsoft Access Database [FULL]

In this VB.NET database tutorial I will demonstrate how to connect to a Microsoft Access Database, and how populate a DataGridView and a ComboBox with your query results. Additionally, we will create a wildcard driven database search.

PROJECT RESOURCES:


SEGMENTED TUTORIAL [4 PARTS]:

Thank you for supporting VBToolBox!

[johnnyhermes]

Hello MR Big Island (AKA VB Toolbox)...
All my life I was passionated by programming and 20 years ago I started learning VB on my own.
I've accomplished some cool things along the way and thought I was pretty good at it.
Then I found your YT channel and you gave me a whole other (and way way way better) understanding of programming VB.
This has changed the game for me and I want to thank you for all the effort you put into making these videaos.
I've nearly watched them all and learn new things each time I watch them.

Enjoy the island and live life!

[barklaysaunders]

This is an incredible piece of coding. I highly recommend you watch all 5 videos ... it will change your world! ... Thank you.

[digitalworld]

My VB6 project was not working but with your help I will be able to convert it again to VB10, thank you BRO. thanks a lot....

[ankurpatel]

Awesome Tutorial!!!
I was almost exhausted and about to quit on developing Billing system and eventually found your tutorial as a life saver. Thank you!!!

[TheRealKaiProton]

Wanted to user this style of Access DBase for a few years, instead I just learned ACCESS, and figured out how to remove the ribbons and the Main Database window, and leave it with just the form, worked ok, just didnt look great, and finally 5yrs later I found this... and its smooth as butter, just followed along with vs2019 and BOOM! worked.. Awesome Tut!

Also, because of the Structure you set up, I was able to plug in the combobox to do a user search in the same way as the text box, YAY!

[LegoStarWarsUpdater]

Thank you, As a self Thought coder, This has been extremely well done. It filled a bunch of gaps for me. Your paste is just perfect, the content is A+. Thank You.

[jprism]

Just wanted to say Awesome Thank You! I have been developing, selling and supporting a program "Prism" for 18 years using VB 6 and 2 days ago installed VB Net 2019 and started try to learn how to use it to rewrite our program. We use MS Access databases to store all data and your video was the only one I found on YouTube where in 1 hour I could open all .mdb files local and across a network+++

[k.w.fisher]

I just have to say that this is still a good video tutorial. I had to change the project to compile for "Any CPU" and make a project reference "Microsoft Office 16 Access Database Engine Object" and it still worked perfect. Thanks

[MoJoTec]

I have been working on a project for weeks. This video and several others from you have solved problems I have encountered and have had challenges overcoming. Excellent, excellent tutorials and explanations!!! Thank you

[jms]

This tutorial actually works, other people use the mystery controls/containers like "DataSet", "BindingSource",  and "SQLDataAdapter",  but he uses code showing what is actually happening. (You remember better when you understand.) He also explains why he uses "Show" event instead of "Load" and why.

[dksuthar]

thank you very much sir!! never thought one can handle database with one single database class. Thank you for source code as well..

[scottthomas]

First tutorial I have watched from you. This was exceptional! Thank you.

[amberm]

Amazing ! Thanks you so much ;) The most amazing part is that you explain everything clearly so that when i do my presentation i could explain how i actually did it

[ashavarghese]

hello sir, ThankYou soo.. much for your tutorials, its the first time that i am going to code in vb.net for my final year bca project only because of your simple and easy tutorials.. thankyou 1's again

[trollstrings]

Only 6 words! Thank you! Thank you! Thank you! 👍👍👍

[randym]

Don't know if you will ever see this but... This video is probably the best I have ever seen on programming, bar none! Aside from the specific issues addressed, the pace is great, I can understand your accent (a huge issue on youtube IMHO), the explanations are clear.

Many years ago I started learning VB6 on my own. Now I am trying to come up to speed on VB.Net and the issues have always been the same: the ability to communicate in a way that is organized, clear, and concise. All of these go toward making the information interesting. Keep up the good work. I am looking forward to watching your other videos. How can we repay you?

[peterbambenek]

Excellent tutorial and understandable. Needed this for searching external DB for my software app inside a created report form.

[Gestapoz]

You are the best of the best
Simple and easy
Keep going and don't stop!.

[nitro]

Thank you VERY much for this informative and detailed tutorial.

[adamali]

Amazing video, perfectly explains everything.