
BeginTrans|Commit|Rollback
->I am trying to use the Workspace.BeginTrans methods with VB4.0 to do
some
->additions and updates to an Access95 database. What is the proper
syntax to
->do that? Due to some reason, it is not recognizing these commands,
it
->updates the database even without the Commit and gives me an error
when I
->try to rollback(says "trying to use Rollback without BeginTrans")
There are any number of operations that can trash a transaction in
progress. Refresh statements and unloading Forms while a transaction
is active are just a couple.
You can find more info on this in MS KB (http://www.microsoft.com/kb)
article Q110722.
Paul
~~~~