transaction and form savepoint

[Rodolfo Rughi]

Hello all,

I have a form for editing multiple records prior to a
batch update based on these records. This form should
support an 'undo' of all edits back to the starting point,
after which the form should remain open and allow further
edits until ultimately commiting or cancelling all changes.

I tried to accomplish this using a transaction, but when I
execute a rollback it closes down the transaction. I have
also tried to use a transaction savepoint (through
cnn.Execute statements) but have come up short here too...

Is it possible to create a savepoint for a transaction in
ADO? Can I accomplish this through some other means?

Thanks for any suggestions,
TK

 

[Sylvain Lafontaine]

It's a bad idea using transactions as a saving point for edition purpose,
especially under Access. (Transactions were not created to store temporary
edits and, above that, Access is not well friendly with transactions.)

A much better idea will be to use a disconnected recordset, temporary tables
(temporary for you application, not necessarily SQL-Server temporary tables)
or an unbound form.

S. L.