It goes FATAL without you needing to write ANY code!
If you have one minute try the following... Create a new data source pointing to an existing microsoft access 2003 database (*.mdb don't use connection strings or SQL or anything complex) but do ask for at least one table (prefferably of few columns) Drag one table from the data source onto virgin form1 and magically a grid and navagator will appear. Run the program and you will find 'Add new' & 'Save Data' work superbly until you either modify or delete a reocrd when it goes fatal in *,Designer.vb and thereafter all changes are lost.
Public Overloads Overridable Function Update(ByVal dataTable As *DataSet.*DataTable) As Integer Return Me.Adapter.Update(dataTable) End Function the Return line triggers 'InvalidOperationException was unhandled' warnings Update requires a valid UpdateCommand when passed DataRow collection with modified rows. or Update requires a valid DeleteCommand when passed DataRow collection with deleted rows.
PS Am I going mad, vs2005 cannot use same field name in multiple tables! PPS Is it just me or have ms left the remaining 40% of the BASIC language out of dotNET?