transactions

bahadur

Having some problems with transactions using Access 2007.

I have a table called test with just one column named 'field' which is numeric.

Why does the following work:

Expand|Select|Wrap|Line Numbers

 
  Set ws = DBEngine(0)

  Set db = ws(0)
 
  ws.BeginTrans
 
      strSql = "INSERT INTO test VALUES(3)"

      db.Execute strSql, dbFailOnError
 
  ws.Rollback

But the following does NOT:

Expand|Select|Wrap|Line Numbers

 
  Set ws = DBEngine(0)

  Set db = ws(0)
 
  ws.BeginTrans

      DoCmd.OpenForm "test1", acNormal, "", "", , acDialog

  ws.Rollback

where test1 is just a continous form generated from table test using the wizard.

It seems that the chages mad are successfully rolled back in the first snippet but not in the second. Obviously there is something I don't understand about Access. Thanks for all/any help.

ADezii

Quote:

Originally Posted by bahadur

Having some problems with transactions using Access 2007.

I have a table called test with just one column named 'field' which is numeric.

Why does the following work:

Expand|Select|Wrap|Line Numbers

 
  Set ws = DBEngine(0)

  Set db = ws(0)
 
  ws.BeginTrans
 
      strSql = "INSERT INTO test VALUES(3)"

      db.Execute strSql, dbFailOnError
 
  ws.Rollback

But the following does NOT:

Expand|Select|Wrap|Line Numbers

 
  Set ws = DBEngine(0)

  Set db = ws(0)
 
  ws.BeginTrans

      DoCmd.OpenForm "test1", acNormal, "", "", , acDialog

  ws.Rollback

where test1 is just a continous form generated from table test using the wizard.

It seems that the chages mad are successfully rolled back in the first snippet but not in the second. Obviously there is something I don't understand about Access. Thanks for all/any help.

Transaction Processing refers to the process of grouping changes to your data into a Batch that is treated as a single atomic unit. Either the entire Batch of Transactions succeed, or they all fail. To put it simple, you have taken the term totally out of context, you cannot Rollback the opening of a Form.

bahadur

Quote:

Originally Posted by ADezii

Transaction Processing refers to the process of grouping changes to your data into a Batch that is treated as a single atomic unit. Either the entire Batch of Transactions succeed, or they all fail. To put it simple, you have taken the term totally out of context, you cannot Rollback the opening of a Form.

Sorry if I confused people. But I was not expecting the opening of the form to be rolled back - but just any changes to the (underlying) table made via the form e.g. deletes, inserts, updates ....

I hope that clarifies my question.

ADezii

Quote:

Originally Posted by bahadur

Sorry if I confused people. But I was not expecting the opening of the form to be rolled back - but just any changes to the (underlying) table made via the form e.g. deletes, inserts, updates ....

I hope that clarifies my question.

To the best of my knowledge, the response is still the same. You cannot Rollback changes made to data via a Form interface,

transactions

re: transactions

re: transactions

re: transactions

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about