Hi all,

Situation:
----------
1) I've created DataAdapters to about a dozen tables in msAccess (1  
adapter per table)
2) I've created a dataset using the visual XML designer in VS2003, adding  
all the realtions=> results in dataset class "dsPS"
3) Retepeated step one for an identical (as far as possible) datastructure  
in MS SQLserver 2000
4) Created two instances of the Dataset class, namely "PSc" and "PSo"
5) Loaded the msAccess data into PSc using the fill command about a dozen  
times.
6) Did the same thing with the data from SQLserver, put that into PSo  
using msSQL dedicated DataAdaptors

Scenario
--------
So far so good, no problems. There's actually a third database that I use  
to register some metadata but it's not directly tied into either of these  
and works fine (that one is in the same SQLserver btw).

The basic idea is to sync the two databases where msAccess is leading with  
some users on the msAccess db and some on the SQLserver. The SQLserver  
"copy" starts off empty, msAccess is the leading database. The  
synchronisation goes perfectly internally (in the datasets), all the  
feedback is as expected. However once the datasets are sorted out, data  
must then be inserted into the SQLserver. Seems pretty straightforward and  
something like: myDataAdapted_formyMyTable.Update(dsPSo.myTable); But it  
doesn't insert any rows.

Situation at time of problem
----------------------------
a) The dataset "PSo" has a correct rowcount
b) SQLserver works because I can insert into other tables (the metadata db)
c) All tables are empty
d) The updates are called in a sequence that takes the relations into  
account (parents before children)
e) Nothing happens when the code runs, it just traces over the code  
without results in SQLserver

Bottomline
----------
I should be able to use one DataSet class for two sets of DataAdapters if  
the structure is identical right? What am I missing?

Thnx for any help!