vba BeginTrans CommitTrans Rollback Methods

[Susy]

Hi there!



silly question.. when do I need to use the methods mentioned above (BeginTrans, Commit and Rollback)?

Do I need to use them always when I am working with recordsets, creating queries?

Thanks again,

Regards!

[June7]

I have one db which has used these methods for complicated processes that modify data - mostly involving deleting but a couple that create records. Data integrity in this db does not rely entirely on established relationships but is instead tightly controlled by hidden nav pane, disabled shortcuts and menus, ribbon customization, form design, and lots of code.

No idea why would be needed for creating queries.

[Susy]

Thanks for the info. Just wanted to know.