Microsoft Access database will not update using Visual Basic 2005 Express

I have created a form to access a table in Access 2000 format. I can browse the records and everything looks fine, but when I update or add new records they aren't being saved to the database. I've included these lines in the save button of the binding navigator

AffectedRows = Me.EmployeesTableAdapter1.Update(Me.CompmanDataSet1.Employees)

If AffectedRows = 0 Then
MessageBox.Show("RECORD WAS NOT UPDATED","DATABASE INFORMATION")
Else
MessageBox.Show(AffectedRows.ToString() & " RECORDS WERE SUCCESSFULLY SAVED", "DATABASE INFORMATION")
End If

It says that 1 record was successfully saved. What am I missing

Answer this question