Updating to Access

[Brad Allison]

Hello,

I am new to ADO and VB.Net. I am not new to using Access. I am in the
process of creating a very large entry system for dog shows and I am having
a problem. All seems to work except one very important thing and that is
saving the actual data that has been input to the bound controls between my
Windows VB form and the actual Access table. I know that this is a very
broad and general topic, but any little information may help.

I have my ole db data adapter, my datasets in place and I have code that
reads
oledbdataadapter1.update(dsDataset1)
When this runs, no data is updated. I have read about data tables, data
views, adding rows, insert, update, delete, etc, but I am missing something
other than simply creating a data adapter, creating a dataset and then using
the data adapters update to write changed or new records back to the Access
table.

Again, thanks for any information.

Brad

 

[Simon Stewart]

Are you sure that the Access file isn't readonly?


Simon

 

[Brad Allison]

The access file is not read only. Do I have to create a data table?

 

[Simon Stewart]

If you examine the RowState property of datarow in the dataset, what is the
value?

Cheers,

Simon Stewart
Johannesburg, South Africa

 

[Bernie Yaeger]

Brad,

Did you write an updatecommand? Are you using a commandbuilder to update?
I'll bet this is where the problem is.

HTH,
Bernie Yaeger

 

[Brad Allison]

For some reason I decided to also view the schema. On several (I use 8) of
the datasets the view schema was greyed out. Now I went in to create a new
dataset from the Data menu and it worked! The former 8 datasets were
created by selecting the data adapter and then clicking on the link to
generate a dataset. Is there a difference? I do know that there is
something about a typed dataset and an untyped dataset.

But now I think I am on the right track.

Brad

 

[Bernie Yaeger]

Hi Brad,

You're going too far afield. Let me tell you this again, because it is the
classic 'no backend update but I don't get an error message' problem:
Did you create and insert command? If not, did you use the commandbuilder?
If you did neither of these, it will not update the back end.

Bernie