The short form of the question is, "How do I create an updatable recordset
and limit it such that it only updates the database when I tell it to?"
This should be a fairly simple thing in principle, but going through online
help and various books, it seems completely impossible. The Microsoft tech
note (<http://premium.microsoft.com/support/kb/articles/q172/3/81.asp>) on
VB Data controls and paused commitment looks promising, but I want to be
able to do this with recordsets I create and attach to generic ODBC
databases. Normally when you open a recordset, it's either completely
unchangeable or automatically updating. Where's the happy middle ground?
I'm also wondering how I can use the spiffy databound controls with any
ODBC database I choose -- how do you bind the Data control when you can't
set .database to a database you've opened? -- but I imagine I'll figure
that out. Is there a particular reason why the language makes this
difficult to do?
Emailed responses are better than posts, but I'll come back and check
periodically. Advice would be much appreciated.