Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dataset wont update my database

Status
Not open for further replies.
Unfortunately I am not allowed to unzip files from an unknown source so cannot view your solution. Generally for a table to be updatable, a primary key needs to be defined. Is this the case?

Beir bua agus beannacht!
 
Yes, I have a primary key on the table. It is an autonumber field within a Microsoft Access database.
 
I tried changing the field to a long integer and deleting a record it does update the dataset but still not the database.

' update database
Me.Validate()
Me.TblContactsBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.ContactsDataSet)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top