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

[@alphaq808]

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...

[@noitsmonday]

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

[@alfredanero9686]

@@noitsmonday same to my problem.

[@noitsmonday]

@@alfredanero9686 so what the solving

[@noitsmonday]

@@alfredanero9686 did you already got it?

[@alfredanero9686]

@@noitsmonday i dont know how.

[@DeagleDamo]

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!

[@alphaq808]

Just Noticed : )

[@kh-music2328]

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

[@mizanzlk]

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.

[@nigelmasiya423]

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

[@faraigilbertmusariri255]

any solution on this?

[@kyrollosemad5319]

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]

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

[@mrblackblade9217]

@@alphaq808 Office 365

[@mrblackblade9217]

@@alphaq808 Does it not work with newer versions?

[@kyrollosemad5319]

@@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

[@mcbryan2243]

currently using vs 2019, why am i missing the oledDbConnection

[@CodingXpert]

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

[@thethornface1485]

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

[@mohammedsaeeddowelbite386]

thank you very much good lecture that I benefit from it

[@bhoomisamadhiya382]

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

[@09-poonamkhandagale92]

It showing exception unhandled, What should I do ?

[@kalbaryo-chika-gaming]

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?

[@janakahewage8327]

Thank You so much its work Nicely

[@samruddhidhoke9186]

connection string property has not been initialized????

[@alphaq808]

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

[@samruddhidhoke9186]

@@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]

@@alphaq808 hi sir my error is solve thanks

[@MicRodrgz]

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

[@mamamagagaga3519]

same problem can u help me too?

[@sumathivelmurugan4708]

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

[@w4tchmonk3y51]

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

[@marbasnoviedamee.5960]

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

[@adamwhite1971]

Easy to follow and fast, thank you very much!

[@kentesver8107]

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.

[@anishazadmusical5821]

great great and great😭

[@michaelmothiba465]

How can i fix the system.missingmemberexception error

[@priyadharsinir1469]

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]

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

[@gabo7966]

Very helpful thank you!

[@mannukim]

hey ALPHA you've helped a lot thanks.

[@kgosimagano8966]

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]

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

[@frogt6931]

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

[@alphaq808]

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

[@frogt6931]

Hope u can make it more easier, thank you

[@alphaq808]

kzbin.info/www/bejne/p52ucqyBesukfsk, hope, you'll get what you asked for.

[@CodingXpert]

In my pc error come after run

[@dweignharly3988]

Thankyousomuch! Godbless

[@DeagleDamo]

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]

Create sign up page to add more Accounts in Database.

[@shasvatasyivaan9869]

"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]

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

[@ThaidrillLao]

thank you so much

[@merlingracy9588]

How to solve connection string property has not initialized error

[@alphaq808]

Assign the connection string to the connection object .

[@starlova2444]

Great job thank you

[@jeinsenmirasol5559]

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

[@rabbit4123]

Same problem here

[@adeeghayemarket]

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

[@daraorn7058]

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

[@alphaq808]

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]

@@alphaq808 Thank u

[@daraorn7058]

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

[@markdelatorre3888]

same problem

[@startpointcorporation9203]

Thanks! Great Tutorial

[@jahzielperalta484]

Nice background bro

[@sonalnehare3128]

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

[@alphaq808]

Store the user values in resource strings...

[@rohitangadi3764]

System. Data. Oledbexception syntex error in FORM clause

[@rajkhalkho9564]

Data type mismatch bol rha hai sir

[@alphaq808]

Make sure database column datatype set to Text.

[@rajkhalkho9564]

Sab check kr liya sir fir bhi nhi ho rha hai

[@rohitangadi3764]

Exception thrown window occurred

[@tarunkumar6181]

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

[@alphaq808]

Sure! :)

[@stxz003]

thank you bro !!!!!

[@fategaming123]

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

[@loisarcangeles3954]

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?

[@scorphack9190]

thanks

[@THEBRIDEOFJESUS23]

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]

Back ground music is very boring