VB.NET MS Access Database Tutorial 1 # How to Connect Access Database to VB.Net

Sdílet
Vložit
  • čas přidán 4. 07. 2014
  • ★★★Top Online Courses From ProgrammingKnowledge ★★★
    Python Programming Course ➡️ bit.ly/2vsuMaS ⚫️ bit.ly/2GOaeQB
    Java Programming Course ➡️ bit.ly/2GEfQMf ⚫️ bit.ly/2Vvjy4a
    Bash Shell Scripting Course ➡️ bit.ly/2DBVF0C ⚫️ bit.ly/2UM06vF
    Linux Command Line Tutorials ➡️ bit.ly/2IXuil0 ⚫️ bit.ly/2IXukt8
    C Programming Course ➡️ bit.ly/2GQCiD1 ⚫️ bit.ly/2ZGN6ej
    C++ Programming Course ➡️ bit.ly/2V4oEVJ ⚫️ bit.ly/2XMvqMs
    PHP Programming Course ➡️ bit.ly/2XP71WH ⚫️ bit.ly/2vs3od6
    Android Development Course ➡️ bit.ly/2UHih5H ⚫️ bit.ly/2IMhVci
    C# Programming Course ➡️ bit.ly/2Vr7HEl ⚫️ bit.ly/2W6RXTU
    JavaFx Programming Course ➡️ bit.ly/2XMvZWA ⚫️ bit.ly/2V2CoAi
    NodeJs Programming Course ➡️ bit.ly/2GPg7gA ⚫️ bit.ly/2GQYTQ2
    Jenkins Course For Developers and DevOps ➡️ bit.ly/2Wd4l4W ⚫️ bit.ly/2J1B1ug
    Scala Programming Tutorial Course ➡️ bit.ly/2PysyA4 ⚫️ bit.ly/2PCaVj2
    Bootstrap Responsive Web Design Tutorial ➡️ bit.ly/2DFQ2yC ⚫️ bit.ly/2VoJWwH
    MongoDB Tutorial Course ➡️ bit.ly/2LaCJfP ⚫️ bit.ly/2WaI7Ap
    QT C++ GUI Tutorial For Beginners ➡️ bit.ly/2vwqHSZ
    ★★★ Online Courses to learn ★★★
    Get 2 FREE Months of Unlimited Classes from skillshare - skillshare.eqcm.net/r1KEj
    Data Science - bit.ly/2lD9h5L | bit.ly/2lI8wIl
    Machine Learning - bit.ly/2WGGQpb | bit.ly/2GghLXX
    Artificial Intelligence - bit.ly/2lYqaYx | bit.ly/2NmaPya
    MERN Stack E-Degree Program - bit.ly/2kx2NFe | bit.ly/2lWj4no
    DevOps E-degree - bit.ly/2k1PwUQ | bit.ly/2k8Ypfy
    Data Analytics with R - bit.ly/2lBKqz8 | bit.ly/2lAjos3
    AWS Certification Training - bit.ly/2kmLtTu | bit.ly/2lAkQL1
    Projects in Java - bit.ly/2kzn25d | bit.ly/2lBMffs
    Machine Learning With TensorFlow - bit.ly/2m1z3AF | bit.ly/2lBMhnA
    Angular 8 - Complete Essential Guide - bit.ly/2lYvYRP
    Kotlin Android Development Masterclass - bit.ly/2GcblsI
    Learn iOS Programming Building Advance Projects - bit.ly/2kyX7ue
    ★★★ Follow ★★★
    My Website - www.codebind.com
    DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This help support the channel and allows us to continue to make videos like this. Thank you for the support!
    Searches related to vb.net access database
    vb.net access database tutorial
    vb.net access database update records
    vb.net access database connection
    vb.net access database search
    vb.net access database connection code
    vb.net access database tutorial pdf
    Visual Basic .NET programming for Beginners
    A Really Simple Database - VB.NET Tutorials |
    A Basic VB.NET ADO.NET Tutorial
    vb.net access database connection string
    vb.net access database project download

Komentáře • 162

  • @PetesCreativeRecycling
    @PetesCreativeRecycling Před 8 lety +9

    I spent the last hour and a half coding to make this work and finally I was like "screw this, lets see what youtube has"
    I went straight to this channel and found what I was looking for. Link - select - drag - drop - done. THANK YOU!

  • @jadl00
    @jadl00 Před 7 lety +1

    I want to thank you a lot cause I was trying to learn this topics in spanish but i could not find any tutorial such as good like this one. Congratulations, you explain made it very clear to understand.

  • @nameless7779
    @nameless7779 Před 8 lety +2

    Absolutly perfect for my project. Your tuto will help me a lot to understand the theory and I can practice !!
    Thank you very much !!
    New follower ;)

  • @billycapiche3969
    @billycapiche3969 Před 4 lety +2

    Very well done. Was able to follow along with no issues. Thanks.

  • @rogerbreton6412
    @rogerbreton6412 Před 5 lety +1

    Thank you so much for taking the time to explain!

  • @theiammike123
    @theiammike123 Před 9 lety

    You just solved my problem. Thanks, man.

  • @scipics
    @scipics Před 9 lety +1

    great tutorial instead of coding its a shortcut drag and drop

  • @mahanandasn
    @mahanandasn Před 5 lety +1

    Love this tutorials very much...god bless you...Need How to create DLLs for some applications...

  • @robincarlsson1121
    @robincarlsson1121 Před 6 lety

    learned alot from you videos, good job! i would realy like if you made a video in how you can add photos to your database and link them to the correct profile

  • @ahamadhsaadhiq5743
    @ahamadhsaadhiq5743 Před 8 lety

    WoW! It was Awesome. Thank u very much. Please add more videos on VB2010

  • @EasyDYITech
    @EasyDYITech Před 10 lety +1

    Awesome tutorial I've been looking for something like this to use in my projects. Are there any limitations on accessing the database over online sources.

  • @mazkot031
    @mazkot031 Před 10 lety

    thanks a lot, your a big help... i can now do my projects....more power..

  • @jonathanjrpaniza3815
    @jonathanjrpaniza3815 Před 7 lety

    thank you It helps me a lot for thesis

  • @GameCenterAZ
    @GameCenterAZ Před 6 lety

    TY bro! soo much! it is best tutorial!!! congrats!

  • @ProgrammingKnowledge
    @ProgrammingKnowledge  Před 10 lety +3

  • @ProjektNoiseBox
    @ProjektNoiseBox Před 7 lety

    dude, youre awesome. subbed

  • @abdiqaadirismail2919
    @abdiqaadirismail2919 Před 8 lety +1

    i enjoy th vb.net program thanks all you

  • @iqbal7888
    @iqbal7888 Před 7 lety

    If I have datatype text with Lookup values in my database table and I want the combobox on my form , how I can do that ?
    I tried to change the control type in datasource of that column of the table and dragged on to form. When I run it doesn't shows the values, it just shows the blank combobox.

  • @nuhella5623
    @nuhella5623 Před 7 lety

    Was soooo useful , thx alot

  • @diveshpatel5213
    @diveshpatel5213 Před 6 lety

    your the boss man >>>>> Awesomeness

  • @sohailzubair1768
    @sohailzubair1768 Před 9 lety +1

    excellent awesome

  • @tendaialbertmubonderi1014

    This is cool and all that. If you could send a video with the coding method

  • @meganoob9281
    @meganoob9281 Před 7 lety

    You have very good English. Thanks for the easy to follow tutorial, my friend.

  • @robbiepascua
    @robbiepascua Před 4 lety +1

    What if you need to update your datasource? For example, you forgot to add another field in access database. So you add it on the database. Now, since you have already connected that database to vb.net net, how will you be able to reflect the added field into the previously connected datasource?

  • @mscoco1431
    @mscoco1431 Před 4 lety

    you are the best teacher

  • @silentteacher2023
    @silentteacher2023 Před 6 lety

    thanks great help for us

  • @bhavnanimgade3673
    @bhavnanimgade3673 Před 5 lety

    very usefull thanks a lot .

  • @stefansutherland1413
    @stefansutherland1413 Před 8 lety

    Thank You for this video.
    Whenever i drag and drop my data set into the form I don't get the tab on the top which enables you to add,delete or save.
    someone please assist

  • @franklinmadukaku9234
    @franklinmadukaku9234 Před 8 lety +1

    Hello Thanks for the video, But I have some difficulties, when i add data, I couldn't find it in my database after I used your tutorial. Please I need urgent help.

  • @khalidramadhan8687
    @khalidramadhan8687 Před 4 lety

    hi sir , when i make setup for project include empty database access and fill it from data grid view and when install on another computer .display massage that cannot know the path of database ....thanks with best regard

  • @lakshmiprabhamoovendan7175

    thank u for the useful tutorial.but when i add records it not save in access y. i don't know.please help me

  • @bacongamer889
    @bacongamer889 Před 8 lety

    THANK U!

  • @vidurasuranjan5842
    @vidurasuranjan5842 Před 5 lety

    Thanks a-lot bro

  • @awconti
    @awconti Před 9 lety +1

    Hi,
    Nice tactic, one that is not used when using other relational databases.
    I'm trying to add a combo-box feature for patients that are Male or Female, what data type would I use? When I drag and drop it's just a textbox....

    • @awconti
      @awconti Před 9 lety +1

      Nevermind -- if there are others who are having the same problem as me... delete the textbox and create a combo-box. You can link the data to the combo-box by going to the properties of the combo-box and selecting "Data-Bindings."

  • @user-jb4nc1kw6x
    @user-jb4nc1kw6x Před 6 lety

    you're the best

  • @briankylegarsuta1190
    @briankylegarsuta1190 Před 5 lety

    Okay the video up above works perfectly but I have this problem that is bugging me, Same codes, similar outputs, 1 table was able to be transfered but the other tables weren't able to be transfered data. Care to help:>

  • @malikabbas9551
    @malikabbas9551 Před 5 lety

    Thank You Sir

  • @rinaprajapat18
    @rinaprajapat18 Před 6 lety

    Thank you sir

  • @SouravSamanta4
    @SouravSamanta4 Před 8 lety

    Helpful

  • @slimshady392
    @slimshady392 Před 2 lety

    Fantastic!

  • @tonybigan8344
    @tonybigan8344 Před 10 lety +1

    can you do the same for sql database?

  • @maaroufiwassim2515
    @maaroufiwassim2515 Před 6 lety

    Thank u friend

  • @awcheeseng
    @awcheeseng Před 3 lety

    Ok found it is "Select the database in Solution Explorer, select properties, select Copy to Output folder. Set to "Copy if newer"

  • @sathishkumarsubramanian2507

    Thank you bro

  • @dhavinweddy701
    @dhavinweddy701 Před 7 lety

    Hello, I need help...Does someone know how to change one of the dragged textboxes to a combo box while it still being connected to the database ?

  • @sanashahin7971
    @sanashahin7971 Před 8 lety +1

    when i run my project ...i dont find my records on the table....what to do..???
    InvalidOperationException was unhandled............this message is appear.....

  • @KbsKbs1993
    @KbsKbs1993 Před 5 lety

    Everytime i run my program and input some data in database, it shows in datagridview. But once I close and open my program again, Datas are gone. Even in MS Acess DB. Help

  • @suprithamahesh8134
    @suprithamahesh8134 Před 7 lety

    I have a problem wen I connect d access database with extension .accdb ( cuz I'm using office 2016) it is saying unrecognised database format I even changed d extension to .mdb still it isn't working pls help

  • @sqlnhjony7084
    @sqlnhjony7084 Před 6 lety

    thanks bro

  • @BryceSchlamp
    @BryceSchlamp Před rokem

    Thanks for the great tutorial! I am having an issue where when I close the program is visual studio and then re-run the program the data is not updated... it is still the original data table that was synced with the project. Any way to change this?

    • @KJimah
      @KJimah Před 5 měsíci

      Same here .. did you get a solution?

  • @vinudasari86
    @vinudasari86 Před 9 lety

    sir how to save images into ms acess database using the same method you have shown in the vedio
    plz replay me

  • @vickic96100
    @vickic96100 Před 8 lety

    If I want to do another form do connect to the database again and select my information again?

    • @PetesCreativeRecycling
      @PetesCreativeRecycling Před 8 lety

      +Vicki Chittenden Just use the same data sources. If it's all the same project you don't need to add the DB again. In fact, if you did add the DB again you would only be making another copy of that DB and not editing it between forms... and that would be terrible!

  • @ouazizmohammedreda3903

    hi when i close my project the data that i saved is gone and i can't see it in my Database and in my datagrid :s what should i do??

  • @pissonatreelike
    @pissonatreelike Před 8 lety

    I keep getting this message "Could not retrieve schema information for table or view" and it seems to be stopping showing the coloum titles and means the detals thing doesn't work

  • @ishmaeljohnson45
    @ishmaeljohnson45 Před 6 lety

    am much greatefull

  • @besamahmed692
    @besamahmed692 Před 2 lety

    How can i permit only one user to log in into my application at the same time and update database, Access local database?, because when more than one user logs in at the same time only the first will have his data stored in Access database file and not the others. Do you have a solution for this issue pls?

  • @timadams3975
    @timadams3975 Před 6 lety

    How do you save the database? My bindingnavigator doesn't put the save button on there.

  • @emmanuelmarcos9219
    @emmanuelmarcos9219 Před 9 lety +1

    i have a problem whenever I drag drop data data source it appears in datagridview not textboxes
    help pls

    • @ari_metal95
      @ari_metal95 Před 9 lety

      Did you do what he explained in 9:44 ?

    • @tejashrirao
      @tejashrirao Před 6 lety

      Before draggind just click on the drop down list and click on details and then drag .... u will find the textboxes

  • @mariancator775
    @mariancator775 Před 6 lety

    i already copied my database to project/bin/debug but still not showing any new records in ms access.. what to do?? :(

  • @psstansberry
    @psstansberry Před 8 lety +1

    It would have been nice if you said the Microsoft Access Database Needed to be 2003

  • @geetharam1579
    @geetharam1579 Před 9 lety +1

    thank uuuuu...its working

  • @steven3837
    @steven3837 Před rokem

    When I tested it said "The Microsoft. ACE.OLEDB provider cannot be used in Visual Studio because it is either 64-bit only or not installed." I've been struggling with this forever if you can please help

  • @emzcruz0957
    @emzcruz0957 Před 7 lety

    hello sir i have a problem in running the problem, when i add item its not appearing and occur occurred say .addnew() its dull

  • @lorieldesamito3998
    @lorieldesamito3998 Před 5 lety

    Can u edit the location after connecting it?

  • @jemilmangukiya8134
    @jemilmangukiya8134 Před 2 lety

    Withevents varible 'update' conflicts with sub 'update' in the base class control and should be declared 'Shadows'.
    How can i solve It please suggest me? 🙏

  • @paavangupta3420
    @paavangupta3420 Před 6 lety

    Sir, whenever i am connecting my ms access database to my VB program then my computer gets hanged,
    what to do now

  • @stennettmullings
    @stennettmullings Před 7 lety

    Can you show me how to login to another screen from the database you created?
    if not whats the code?

  • @jasonomac8063
    @jasonomac8063 Před 9 lety +1

    the data is lost after i save it, and when i open the database again it's gone ....can anyone explain me for that

  • @othmanaljameel7024
    @othmanaljameel7024 Před 8 lety

    When i run the application and insert a new record it temporary, when i exit, it doesn't save it in the db?

  • @zzz11113
    @zzz11113 Před 3 lety

    What should I do if the test connection did not succeed and said the database is unrecognized?

  • @jagjeetsingh-oi5wu
    @jagjeetsingh-oi5wu Před 4 lety

    it is good.. but extremely slow narration........

  • @leonsceco
    @leonsceco Před 9 lety

    @jason"surfer95" Abrahan

  • @BayabasChannel
    @BayabasChannel Před 7 lety

    Please I really need your help!, =(. My problem are when i debug it and saved, nothing gonna saved in my debug database and when i rerun the program nothings saved even i saved data. please reply!. I need you help! i am doing Thesis

  • @yasarshaikh3033
    @yasarshaikh3033 Před 6 lety

    Hi im using Visual Studio 10.
    i cant find Data Source anywhere. i clicked on
    View -> other windows
    and its not there. Where can i find it??

    • @jonasfiestada6039
      @jonasfiestada6039 Před 5 lety

      its on the menu tabs named "Data" > "Show Data Sources" thanks me later :)

  • @digitronix532
    @digitronix532 Před 2 měsíci

    Can be used for 2022 VB ?

  • @bks021
    @bks021 Před 10 lety

    thank you

  • @chipa1203
    @chipa1203 Před 10 lety

    i have problem with this when im start debug,
    An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll
    Additional information: 'D:\KERJAAN DERLY\Visual Basic\MarkTalent\Marktalent\bin\Debug\bin\Marktalent.accdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
    please help me

    • @chipa1203
      @chipa1203 Před 10 lety

      'TODO: This line of code loads data into the 'MarktalentDataSet.RespondenT' table. You can move, or remove it, as needed.
      Me.RespondenTTableAdapter.Fill(Me.MarktalentDataSet.RespondenT)
      i think this is my problem, but im not sure too. :(

  • @cutifyjinhcruz2823
    @cutifyjinhcruz2823 Před 7 lety

    How to put the information in the registration form in a database? please help me I don't what to do?

  • @markodolanc2862
    @markodolanc2862 Před 8 lety

    Hello, I have a problem, when I connect the access database at test connection, I got the message "microsoft.ace.oledb.12.0 provider is not registered on the local machine

    • @levanconfesor9866
      @levanconfesor9866 Před 8 lety +1

      Download this ...
      www.microsoft.com/en-my/download/details.aspx?id=23734

  • @mustafa25804
    @mustafa25804 Před 7 lety

    Everything is fine but when I want to save it, It can't be saved? do you have a solution ?

  • @jeeron2863
    @jeeron2863 Před 7 lety

    this database can be put on payroll?

  • @emjeyureta4202
    @emjeyureta4202 Před 7 lety

    Good video! but i ask question why when i save data from the vb then i open it the data is loss ? how can i solution it thanks !for the answer ..

  • @Marconel100
    @Marconel100 Před 7 lety

    I was taught to change the format of the database and then link it to visual basic, not just link it directly, because it won't even find the database without changing the format, why don't you have to?

  • @Tradingschool786
    @Tradingschool786 Před 6 lety

    please reply me
    how i can compress my project with database access

  • @lemongautam6171
    @lemongautam6171 Před 3 lety

    I got an error which says microsoft.ace.oledb.12.0 provider is not registered how do I overcome this problem ?

  • @rimpalpopat1260
    @rimpalpopat1260 Před 4 lety

    I not able to drag the design from data source. Hence I m not able to see data source window from view menu

  • @null0737
    @null0737 Před 7 lety

    I am too getting an Exception and the Table is not showing its contents up. Please help!!!!

  • @aishastips871
    @aishastips871 Před 6 lety

    error when connecting to ms database.. it says that microsoft ace oledb 12.0 is not installed in your local machine

  • @lancebocek6120
    @lancebocek6120 Před 6 lety

    hey men where can i get a Microsoft Access.. got any links?

  • @wenfrededradan4071
    @wenfrededradan4071 Před 6 lety

    i have an error....."unable to add connection, the given key was not present in the dictionary"...pls help me

  • @adventurously_random
    @adventurously_random Před 9 lety

    good tutorial but it is very annoying when u spend 3-4 min saying something like, its checking if the db is in the project. you replete it 15 times and its pretty obvious what its saying. Try not to drag on with the un necessary parts and itl knock the length down dematicly :)

  • @pamlebrun877
    @pamlebrun877 Před 9 lety +1

    I am getting Code generator for property 'Text' failed. Error was: Object reference not set to an instance of an object'. How do I fix this?

  • @zenoxruiz
    @zenoxruiz Před 8 lety

    Whenever I run the program, then click "Save Data" an error occurs in updating the dataset

  • @miccurriehudube203
    @miccurriehudube203 Před 3 lety

    there is not a better tutorial i believe.

  • @madhuripatil4067
    @madhuripatil4067 Před 8 lety

    hey when I add Database then it says visual basic encountred

  • @jonathanho2641
    @jonathanho2641 Před 5 lety

    I connect access database to data source configuration wizard then i test connection always say unrecognized database format how to fix the problem?? please help me!!!

  • @arijeetdasgupta9818
    @arijeetdasgupta9818 Před 4 lety

    How can we add multiple tables in a database

  • @othmaneaboujaafar2728
    @othmaneaboujaafar2728 Před 8 lety

    cool

  • @ariannabeitler5992
    @ariannabeitler5992 Před 2 lety

    영상으로 다국어 번역하면 더 잘할 수 있어요

  • @cutifyjinhcruz2823
    @cutifyjinhcruz2823 Před 7 lety

    Can someone give me a link of Microsoft Visual Studio 2010 or vb.net. Please help me! I need to finish my system before this Friday comes