G
Guest
Hello,
I'm trying to find out if my form supports transactions. Where do i find
this property?
Thank you
I'm trying to find out if my form supports transactions. Where do i find
this property?
Thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
Bound forms are wrapped within transactions that are not exposed to you.
In Access 2000 and later, it is possible to:
- open a transaction,
- open a recordset inside the transaction,
- assign this recordset to the Recordset property of your form,
thus wrapping your form inside your own transaction.
Unfortunately, there does not seem to be any way to get a subform inside the
same transaction, because Access reassigns it every time you move record in
the main form.
In Access 2000 and later, it is possible to:
- open a transaction,
- open a recordset inside the transaction,
- assign this recordset to the Recordset property of your form,
thus wrapping your form inside your own transaction.
Unfortunately, there does not seem to be any way to get a subform inside the
same transaction, because Access reassigns it every time you move record in
the main form.