Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

MS Access connection problem with VB.NET

VB.NET timer connection

  • Please log in to reply
No replies to this topic

#1 bradploz

bradploz

    CC Lurker

  • Just Joined
  • Pip
  • 6 posts

Posted 29 July 2011 - 02:50 AM

hello, I am trying to connect MS ACCESS 2007 Database with textboxes which will show the info of the users..for example..when I login..I see my info in the textboxes..and when other user logs in..they can see their info..

This is the code I have on load after the window login..

Private Sub frmemp_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Timer1.Start()
        Try
            conn.Open()
            cmd = New OleDbCommand("SELECT * FROM employees,username WHERE ID=IDE", conn)
            dr = cmd.ExecuteReader
            While dr.Read()
                txtfn.Text = dr(1)
                txtpro.Text = dr(2)
                txtsa.Text = dr(3)
            End While
        Catch
        End Try
        dr.Close()
        conn.Close()

    End Sub

But this code only shows the last user on the row on the database..It is not changing even other users login..for example...I login and I am the last user on the row..I can see my info but when other user logs in..He just see my info..Not his...

Please help..and thanks in advance..
  • 0





Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download