Data Binding to Access Query - Update problem

[Diarmuid]

From the data sources window, I dragged a query called qryWeeks onto my
form. This created
QryWeeksBindingSource
QryWeeksTableAdapter
QryWeeksBindingNavigator

It displays fine, but the Save on qryWeeksBindingNavigator doesn't work. The
error is
"Update requires a valid UpdateCommand when passed DataRow collection with
modified rows."

The error occurs in the Dataset designer, in this function

Public Overloads Overridable Function Update(ByVal dataTable As
HTPlannerDataSet.qryWeeksDataTable) As Integer
Return Me.Adapter.Update(dataTable)

End Function

I have yet to write any code in this project, so I'm wondering what I should
change to get it working.

Thanks

Diarmuid

[Vayse]

anyone got any ideas on this?
"Diarmuid" <di******@deadspam.com> wrote in message
news:ua**************@tk2msftngp13.phx.gbl...

From the data sources window, I dragged a query called qryWeeks onto my
form. This created
QryWeeksBindingSource
QryWeeksTableAdapter
QryWeeksBindingNavigator

It displays fine, but the Save on qryWeeksBindingNavigator doesn't work.
The error is
"Update requires a valid UpdateCommand when passed DataRow collection with
modified rows."

The error occurs in the Dataset designer, in this function

Public Overloads Overridable Function Update(ByVal dataTable As
HTPlannerDataSet.qryWeeksDataTable) As Integer
Return Me.Adapter.Update(dataTable)

End Function

I have yet to write any code in this project, so I'm wondering what I
should change to get it working.

Thanks

Diarmuid