hi....i m actually developing a tool which uses access as the database source...i hv created 2 coloumns in the database....username and password....now in my tool i need to ask the user fr his username and password....if it matches with any of the combinations stored in the database then the user can login ....cn anyone help me wiith dis ....
anud18
0
Junior Poster in Training
Recommended Answers
Jump to PostYou need to open the Access table, and then step through each record testing the value the user has entered with the value in each record. If user name is same then check password to be same.
How far have you got with writing VB to open tables and …
Jump to Postactually i know the steps to do it......but m nt being able to figure out how to connect to the database by using ADO......wen i try to open the database using the following code it opens up a SELECT DATA SOURCE DIALOGUE BOX.....plz help me wid this
Dim dbUserName As …
Jump to Postthanx.... i hv been able to develope the tool......now i further want to modify it...
i.e now i want to connect/open up the database which is password protected....how do i do that through VB
Thanks for letting us know.
I struggled to get a password protected database to open, …
Jump to PostAnud,
Please look in the thread Read Me. Access to any type of DB is possible
started by me.Happy Programming
AV Manoharan
Jump to PostPrivate Sub Cmd_Submit_Click() Adodc1.Recordset.AddNew Adodc1.Recordset.Fields("Contact_No").Value = Txt_Contact.Text Adodc1.Recordset.Fields("Reserv_No").Value = Txt_Reserv_No.Text Adodc1.Recordset.Fields("Reserv_Date").Value = Txt_Date.Text Adodc1.Recordset.Fields("Booking_Time").Value = Txt_Time.Text Adodc1.Recordset.Fields("Type_Code") = Cmb_Type.ListIndex Adodc1.Recordset.Fields("Payment") = Txt_Payment.Text Adodc1.Recordset.Fields("Receipt_No") = Txt_Receipt.Text Adodc1.Recordset.Update MsgBox "Record has been saved", vbOKOnly + vbInformation End Sub
yoiu'll probably get an error if you do not set the …
All 18 Replies
DenisOxon
12
Posting Whiz
anud18
0
Junior Poster in Training
DenisOxon
12
Posting Whiz
anud18
0
Junior Poster in Training
DenisOxon
12
Posting Whiz
anud18
0
Junior Poster in Training
rumi
0
Newbie Poster
AV Manoharan
0
Junior Poster
jireh
3
Posting Whiz
rumi
0
Newbie Poster
jireh
3
Posting Whiz
rumi
0
Newbie Poster
jireh
3
Posting Whiz
rumi
0
Newbie Poster
elleinad
0
Newbie Poster
roshani285
0
Newbie Poster
sackymatt
0
Light Poster
sackymatt
0
Light Poster
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.