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 = 0Then
MessageBox.Show("RECORD WAS NOT UPDATED","DATABASE INFORMATION")
Else
MessageBox.Show(AffectedRows.ToString() &" RECORDS WERE SUCCESSFULLY SAVED","DATABASE INFORMATION")
EndIf

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

[1359 byte] By [RoyA] at [2007-12-17]
# 1
Roy,

This is a common issue that has to do with where and how your database is being saved. See the following thread for an explanation:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=140988&SiteID=1

Steve Hoag
Visual Basic Express

shoagMSFT at 2007-9-8 > top of Msdn Tech,Visual Studio Express Editions,Visual Basic 2005 Express Edition...