Multiple OleDbDataAdapters for single mdb

[BobAchgill]

Is it OK to have more than one OleDbDataAdapte r 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]

Re: Multiple OleDbDataAdapte rs for single mdb

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.


"BobAchgill " <anonymous@disc ussions.microso ft.com> wrote in message
news:19c801c556 c6$f66dc6f0$a50 1280a@phx.gbl.. .
Is it OK to have more than one OleDbDataAdapte r 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