Multiple OleDbDataAdapters for single mdb

[BobAchgill]

Is it OK to have more than one OleDbDataAdapter for a
single MDB file?

The first adaper to the MDB is only doing Selects. That
is working fine.

Though my second adapter is unsuccessful in performing
row Deletes.

Thanks!

Bob

 

[David Lloyd]

Bob:

My understanding is that having multiple dataadapters is quite acceptable.
It is not uncommon to have a different data adapter for each table in a
database. If you are using different dataadapters solely for the purpose of
executing different DML statements on the same table, while this will work,
it probably will make your code more complex and more difficult to follow.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Is it OK to have more than one OleDbDataAdapter for a
single MDB file?

The first adaper to the MDB is only doing Selects. That
is working fine.

Though my second adapter is unsuccessful in performing
row Deletes.

Thanks!

Bob