Form updates are never saved using the binding navigator

  • Thread starter Thread starter sandal
  • Start date Start date
S

sandal

I've watched the "VB How Do I" series and there is seems very simple to
create an updateable form by dragging a table from the Data Sources tab,
as either a grid or a detail, to a form. However when I do it, using an
Access mdb as the data source, nothing is ever saved to the database.
The edits persist as long as the form is open but if closed and
reopened, nothing was committed. The expected code is in place

Me.TblProjectBindingSource.EndEdit()
Me.TblProjectTableAdapter.Update(Me.ConsultDataSet.tblProject)

It's kind of strange to have such a simple attempt fail...what could be
causing this? I've already uninstalled and reinstalled vs. This is the
trial edition (vs 2005 pro, sp1); but I can't believe MS would configure
the trial with edits disabled.
 
I've watched the "VB How Do I" series and there is seems very simple to
create an updateable form by dragging a table from the Data Sources tab,
as either a grid or a detail, to a form. However when I do it, using an
Access mdb as the data source, nothing is ever saved to the database.
The edits persist as long as the form is open but if closed and
reopened, nothing was committed. The expected code is in place

Me.TblProjectBindingSource.EndEdit()
Me.TblProjectTableAdapter.Update(Me.ConsultDataSet.tblProject)

It's kind of strange to have such a simple attempt fail...what could be
causing this? I've already uninstalled and reinstalled vs. This is the
trial edition (vs 2005 pro, sp1); but I can't believe MS would configure
the trial with edits disabled.
Click to expand...
I've installed on a couple of other boxes, with and without sp1, and
none save updates when the save icon is pressed.

I'm not exactly getting overwhelmed by responses here...maybe no one
uses the binding navigator, or the wizard generated implementations are
known to be useless?
 
Did you wrap it in a try catch, put a break on the catch and read the message
That will tell you why it didn't save
 
Back
Top