Unspecified error when performing operations on OLE DB data adapters

  • Thread starter Thread starter Drew Yallop
  • Start date Start date
D

Drew Yallop

I have 7 data adapters connected to MS Access tables. When I try to 1)
Preview Data or 2) Generate DataSet or 3) look at the Mapping collection in
the DA Properties I get "Unspecified Error". Plus one of the data adaptors
generates a bad Update statement that throws an error message when I try to
update after a dataset Merge. None of the other adapters throw an Update
error.

I have tried reconfiguring, recreating and virtually every property
parameter without luck. I have recreated the MS Access table from which the
bad Update command is created. I have deleted the entire form containing the
data adapters and started over again with the same result.

Any thoughts?

Best regards,

Drew Yallop
 
Hi Drew,

Start at the most basic level: create a new form, add one dataadapter, use
the wizard and do a plain vanilla select (select * from custnames or by
custid), generate a new dataset using the dataadapter in the tray, fill the
dataset in the load event. That virtually has to work.

If you're ok to here, then add some insert code - again, very basic - fill
all rows in a newrow object, test the insert, etc.

HTH,

Bernie Yaeger
 
Back
Top