How to create login form with ms-access database in vb.net

Sdílet
Vložit
  • čas přidán 11. 09. 2018
  • VB.NET Video tutorial about creating login form in visual studio using ms-access database
    for adding more accounts into database follow given link below
    • VB.NET | How to create...
    Here's a complete module in vb.net login module(login+registration+checkduplicate number using access database)
    • VB.NET - Create login ...
    After you found this one is helpful Dont Forget to LIKE-SUBSCRUBE and SHARE.
  • Věda a technologie

Komentáře • 101

  • @alphaq808
    @alphaq808  Před 4 lety +7

    If you need any other help about visual basic coding just feel free to ask in the comments section. surely you'll get a helping hand. :) Thank you...

    • @sandwitch00
      @sandwitch00 Před 4 lety +5

      hye..i got problem with dim count = convert.toInt32(cmd.ExecuteScalar())..
      can you help me?

    • @alfredanero9686
      @alfredanero9686 Před 4 lety

      @@sandwitch00 same to my problem.

    • @sandwitch00
      @sandwitch00 Před 4 lety

      @@alfredanero9686 so what the solving

    • @sandwitch00
      @sandwitch00 Před 4 lety

      @@alfredanero9686 did you already got it?

    • @alfredanero9686
      @alfredanero9686 Před 4 lety

      @@sandwitch00 i dont know how.

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

    Hi mate, Just followed this through step by step after watching hours of tutorials that dont work and this one worked and is amazing!, thank you dude!

  • @mizanzlk
    @mizanzlk Před 3 lety +1

    Thank you so much. Works like a charm! Just need to change the table name in the coding to mine in Access and good to go.

  • @kh-music2328
    @kh-music2328 Před 4 lety +5

    help me. System.InvalidOperationException: 'ExecuteScalar requires an open and available Connection. The connection's current state is closed.'Dim count = Convert.ToInt32(cmd.ExecuteScalar())
    If (count > 0) Then

  • @kentesver8107
    @kentesver8107 Před 5 lety

    Hello. Can you please help me? I just followed the steps but unfortunately it doesnt work on me it says that "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll" please help me.

  • @mannukim
    @mannukim Před 5 lety

    hey ALPHA you've helped a lot thanks.

  • @mohammedsaeeddowelbite386

    thank you very much good lecture that I benefit from it

  • @bhoomisamadhiya382
    @bhoomisamadhiya382 Před 3 lety

    Getting an error system.data.oledb.oledbException for connection.open() , what I should do?

  • @kalbaryo-chika-gaming
    @kalbaryo-chika-gaming Před 3 lety

    System.Data.OleDb.OleDbException: 'The Microsoft Jet database engine cannot find the input table or query 'login'. Make sure it exists and that its name is spelled correctly.'
    i have this problem can you help me?

  • @thethornface1485
    @thethornface1485 Před 3 lety

    why my connection.open() has an oledb exception "Invalid authorization specification"

  • @nigelmasiya423
    @nigelmasiya423 Před 3 lety +1

    having a problem when l click login the problem will be indicating >>{(cmd.ExecuteScalar())}

  • @startpointcorporation9203

    Thanks! Great Tutorial

  • @mcbryan2243
    @mcbryan2243 Před 2 lety

    currently using vs 2019, why am i missing the oledDbConnection

  • @gabo7966
    @gabo7966 Před 2 lety

    Very helpful thank you!

  • @CodingXpert
    @CodingXpert Před 3 lety

    The Microsoft Access database engine cannot find the input table or query login ....this error come

  • @marbasnoviedamee.5960
    @marbasnoviedamee.5960 Před 3 lety

    It says that may dim count =Convert.ToInt32(cmd.ExecuteScalar())
    Has no value given for one or more required parameters. why is that?

  • @dweignharly3988
    @dweignharly3988 Před 4 lety

    Thankyousomuch! Godbless

  • @janakahewage8327
    @janakahewage8327 Před 2 lety

    Thank You so much its work Nicely

  • @starlova2444
    @starlova2444 Před 5 lety

    Great job thank you

  • @w4tchmonk3y51
    @w4tchmonk3y51 Před 4 lety

    kuys may tanong ako. pag ka login ko gusto ko kasi sya automatic mag close yung login form pag nag show yung kasunod nyang dialog box

  • @sumathivelmurugan4708
    @sumathivelmurugan4708 Před 3 lety

    I got test connection failed and i am getting this error microsoft.ace.provider is not registered on local machine. how to solve this issue

  • @adamwhite1971
    @adamwhite1971 Před 4 lety

    Easy to follow and fast, thank you very much!

  • @adeeghayemarket
    @adeeghayemarket Před 4 lety

    Thank you very much how i can use module to connect access 2019 and visual studio 2019 thanks again

  • @09-poonamkhandagale92
    @09-poonamkhandagale92 Před 2 lety

    It showing exception unhandled, What should I do ?

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

    help me. i can not add the database after clicking the "new connection" button and browse the database when i click test connection it appears this message box "unrecognized database format" and the location of the file

    • @alphaq808
      @alphaq808  Před 4 lety

      What's the version of ms office you are using ?

    • @mrblackblade9217
      @mrblackblade9217 Před 4 lety

      @@alphaq808 Office 365

    • @mrblackblade9217
      @mrblackblade9217 Před 4 lety

      @@alphaq808 Does it not work with newer versions?

    • @kyrollosemad5319
      @kyrollosemad5319 Před 4 lety

      @@mrblackblade9217 i've finally found the solution! 😎😎
      you have to download and install the Microsoft Access Database Engine 😃
      you can use this link: 👇👇👇👇👇👇👇
      www.microsoft.com/en-us/download/details.aspx?id=54920

  • @michaelmothiba465
    @michaelmothiba465 Před 3 lety

    How can i fix the system.missingmemberexception error

  • @ThaidrillLao
    @ThaidrillLao Před 3 lety

    thank you so much

  • @DeagleDamo
    @DeagleDamo Před 5 lety

    At the moment this only gets the one user name and password from the database, do you know howi could add more usernames and passwords in and use more accounts?

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

      Create sign up page to add more Accounts in Database.

  • @stxz003
    @stxz003 Před 3 lety

    thank you bro !!!!!

  • @priyadharsinir1469
    @priyadharsinir1469 Před 4 lety

    When I give a password field value as integer it doesn't show any error msg... Bt when I give a password field value as date format it shows a error msg at Dim count = convert.ToInt32(cmd.ExecuteScalar()) what should want to do??? Did I want to change a code for that particular line..... Can u help me??

    • @alphaq808
      @alphaq808  Před 4 lety

      Mate, can you be more specific about error? What is the error msg ?

  • @shasvatasyivaan9869
    @shasvatasyivaan9869 Před 4 lety

    "An unhandled exception of type 'System.InvalidOperationException' occurred in System.Data.dll " this shows at the connection state which has connection Closed and connection Open

    • @alphaq808
      @alphaq808  Před 4 lety

      Varify code again, you'll get the missing point.

  • @jahzielperalta484
    @jahzielperalta484 Před 4 lety

    Nice background bro

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

    i am having error " Dim count = Convert.ToInt32(cmd.ExecuteScalar())" what can i do ?

  • @anishazadmusical5821
    @anishazadmusical5821 Před 2 lety

    great great and great😭

  • @CodingXpert
    @CodingXpert Před 3 lety

    In my pc error come after run

  • @rohitangadi3764
    @rohitangadi3764 Před 2 lety

    System. Data. Oledbexception syntex error in FORM clause

  • @kgosimagano8966
    @kgosimagano8966 Před 3 lety

    Thanks so much for this video, it really helped me with my college assignment! Now going off-topic here, what's the name of the background music at 2:08 ?

    • @crazi657
      @crazi657 Před 3 lety

      Song
      Rise Up (Radio Edit)
      Artist
      Yves Larock feat. Jaba
      Album
      Yves Larock's Classic

  • @scorphack9190
    @scorphack9190 Před 5 lety

    thanks

  • @merlingracy9588
    @merlingracy9588 Před 4 lety

    How to solve connection string property has not initialized error

    • @alphaq808
      @alphaq808  Před 4 lety

      Assign the connection string to the connection object .

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

    please do us a favor and kindly remove the background music. its pretty loud and drowns out your words

  • @daraorn7058
    @daraorn7058 Před 4 lety

    erro ExecuteScalar requires an open and available Connection. The connection's current state is closed.

    • @alphaq808
      @alphaq808  Před 4 lety

      Kindly, check your code again and make sure you wrote the if condition to check connection state, if not then write it...
      exp
      If connection.state = ConnectionState.closed then
      connection.open()

    • @daraorn7058
      @daraorn7058 Před 4 lety

      @@alphaq808 Thank u

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

      System.Data.OleDb.OleDbException: 'Syntax error (missing operator) in query expression 'count(*) form tbluser where username=? and password=?'.'

    • @markdelatorre3888
      @markdelatorre3888 Před 3 lety

      same problem

  • @frogt6931
    @frogt6931 Před 4 lety

    Can u make this video by using 2 form which are login and register use the access?

    • @alphaq808
      @alphaq808  Před 4 lety

      Why not, just give me a day and I'll give you a link of new video. :)

    • @frogt6931
      @frogt6931 Před 4 lety

      Hope u can make it more easier, thank you

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

      czcams.com/video/qlKAyKEfqHg/video.html, hope, you'll get what you asked for.

  • @sonalnehare3128
    @sonalnehare3128 Před 4 lety

    Plz tell the coding for login without using database.. simple codeing

    • @alphaq808
      @alphaq808  Před 4 lety

      Store the user values in resource strings...

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

    connection string property has not been initialized????

    • @alphaq808
      @alphaq808  Před 5 lety

      check your connection string is assigned to the connection object or not.
      i can only say this without reviewing actual code.

    • @samruddhidhoke9186
      @samruddhidhoke9186 Před 5 lety

      @@alphaq808 sir connection string problem solve but Dim count = Convert.ToInt32(cmd.ExecuteScalar())
      If (count > 0) but count value is 0 and count value is not changed and database username password not show

    • @samruddhidhoke9186
      @samruddhidhoke9186 Před 5 lety

      @@alphaq808 hi sir my error is solve thanks

    • @MicRodrgz
      @MicRodrgz Před 5 lety

      ​@@samruddhidhoke9186 same error.. how d yyou fix that??

    • @mamamagagaga3519
      @mamamagagaga3519 Před 5 lety

      same problem can u help me too?

  • @rohitangadi3764
    @rohitangadi3764 Před 2 lety

    Exception thrown window occurred

  • @fategaming123
    @fategaming123 Před rokem

    Was trying to watch.. But the background music. Loud af

  • @rajkhalkho9564
    @rajkhalkho9564 Před 4 lety

    Data type mismatch bol rha hai sir

    • @alphaq808
      @alphaq808  Před 4 lety

      Make sure database column datatype set to Text.

    • @rajkhalkho9564
      @rajkhalkho9564 Před 4 lety

      Sab check kr liya sir fir bhi nhi ho rha hai

  • @loisarcangeles3954
    @loisarcangeles3954 Před rokem

    System.Data.OleDb.OleDbException: 'The Microsoft Access database engine cannot find the input table or query 'TB_Admins'. Make sure it exists and that its name is spelled correctly.'
    why does my code does that after i run the program?

  • @THEBRIDEOFJESUS23
    @THEBRIDEOFJESUS23 Před rokem

    HEY THIS CODES WILL NOT WORK DON'T WATS UR TIME DOING IT
    IT WILL GVE YOU ERROR AT THE END MXXXXMMMMMMM WASTED MY TIME FOR NOTHING

  • @haridasvasudevan1826
    @haridasvasudevan1826 Před 2 lety

    Back ground music is very boring