Cancel Changes

Hi Gurus,

You would think this would be a simple problem... but, it is not. I have a multi-tier, multi-user database application written in VB6SP4 with an Access 97 backend. I inherited this project and am trying to do some cleanup on it. I should also add that it is a very large project (approx. 150 forms). Now to the question. Prev programmer used data control to populate forms, make changes to db, cancel changes, etc. I am trying to remove all database changing and cancelling of change capabilites from the data control. What is the best manner in which to cancel changes and repopulate the form with original data? I have several ideas but I don't know which is the best... So, would you mind giving me some ideas of what works best for you.

Thanks in advance,
Yin