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