No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
4 Posted Topics
 | hello, I'm making an enrollment and billing system and I'm just going to ask how do I connect a database in visual basic? I'm using vb 6 and ms access |
| | please help me I'm having error in rs.Open "SELECT * FROM [tbladmin] WHERE [username]= '" & txtUsername.Text & "'", con, adOpenStatic, adLockOptimistic I think my code is right I dunno where I went wrong. Dim strUserName As String, strPassword As String Dim con As New ADODB.Connection Dim rs As New …  |
| | this is my code for the login form using ms access would someone please help me? Everytime I run the program, it usually says connection cannot be used. If I would debug the program it will highlight "rspassword.Open "Select * from table1" I also used a module here Public rs …  |
| | whenever I try to run it I have a compile error in connecting my database this is my code Dim con As Adodb.Recordset Dim conn1 As Adodb.Connection Private Sub mygdb() Set con = New Adodb.Connection con.CursorLocation = adUseClient con.Open "PROVIDER = Microsoft.Jet.OLEDB.4.0;Data Source =" & App.Path & "\enrolment.mdb;" End Sub  |
The End.