Adding Records to an Access Database using VB 2005
I am trying to add records to an existing Access datatable. The dataset, bindingsource, and tableadapter are defined. The following programs runs ok. I can see the new records in a datagrid view, but the source access database is unchanged after I close the program.
Sub AddRecords()
Dim dt As DataTable
Dim dr As DataRow
dt = DbTestDataSet.EventIndex 'the access dataset & datatable
EventIndexTableAdapter.Fil
Dim dr As DataRow
For i = 1 To 5
dr = dt.NewRow()
dr!event = i * 2
dr!timesim = i - 4
dr!date = Now
dr!duration = 89
dt.Rows.Add(dr)
Next
dt.AcceptChanges()
EventIndexTableAdapter.Upd
Sub AddRecords()
Dim dt As DataTable
Dim dr As DataRow
dt = DbTestDataSet.EventIndex 'the access dataset & datatable
EventIndexTableAdapter.Fil
Dim dr As DataRow
For i = 1 To 5
dr = dt.NewRow()
dr!event = i * 2
dr!timesim = i - 4
dr!date = Now
dr!duration = 89
dt.Rows.Add(dr)
Next
dt.AcceptChanges()
EventIndexTableAdapter.Upd
ASKER
Dabas,
The problem was that the dataset was referenced to the wrong file. Apparently VB makes a copy of the database and stores it in a working directory somewhere. So it was making changes to copied database instead of mine. I thought it was supposed to copy that back to my original file when the changes were accepted. But apparently not for some reason.
I changed the file reference in the Project/ Properties/Settings window to the actual source file instead of the copy. After that, it works, whether or not the 'dt.acceptchanges' line is included.
It works, but not as advertised. Any idea why the file refencet would be messed up?
BW
The problem was that the dataset was referenced to the wrong file. Apparently VB makes a copy of the database and stores it in a working directory somewhere. So it was making changes to copied database instead of mine. I thought it was supposed to copy that back to my original file when the changes were accepted. But apparently not for some reason.
I changed the file reference in the Project/ Properties/Settings window to the actual source file instead of the copy. After that, it works, whether or not the 'dt.acceptchanges' line is included.
It works, but not as advertised. Any idea why the file refencet would be messed up?
BW
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
> dt.AcceptChanges()
Try remarking this line and see how it goes
Dabas