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")
Please help...

Thanks,
CJ Singh

->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
~~~~