By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,556 Members | 1,609 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,556 IT Pros & Developers. It's quick & easy.

Multiple OleDbDataAdapters for single mdb

P: n/a
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

Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <an*******@discussions.microsoft.com> wrote in message
news:19****************************@phx.gbl...
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
Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.