Can DataSet objects support multiple OldDbDataAdapter objects?

[DeGeneral]

I am upgrading some VB6 programmes to VB.NET(2005). My main programme feeds data to a number of MSAccess tables. I want to know if I need a separate DataSet object for each table or can I use just one DataSet object to link to the Database and then link to each table with a different OleDbDataAdapter.

If so, then what is the correct syntax for updating hte database because the:

"OleDbTableAdapter1.Update(DataSet1)"

format doesn't work for OleDbTableAdapter2/3/4/etc.

Thanks,

DeGeneral

 

[fawkes]

Each table adpater will update a seperate table

use

OleDbTableAdapter1.Update(DataSet1.Table1)
OleDbTableAdapter2.Update(DataSet1.Table2)