Re: Access and transaction processing...
- From: "Brad Pears" <donotreply@xxxxxxxxxxx>
- Date: Fri, 2 Jun 2006 13:55:40 -0400
Great thanks for that!!
Brad
"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:%23fxnmJmhGHA.4896@xxxxxxxxxxxxxxxxxxxxxxx
Yes. You can RollBack or CommitTrans in DAO.
There are several traps. For a discussion and example, see:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Brad Pears" <donotreply@xxxxxxxxxxx> wrote in message
news:eNVsq8lhGHA.1272@xxxxxxxxxxxxxxxxxxxxxxx
Can Access 2000 even support transaction processing? I have an area in an
existing application that would be ripe for a begin/end and rollback if
user cancels the process... I am currently just using DAO in this app.
It is scheduled for redevelopment in VB .net 2005 and using SQL server
2000 instead - which obviously supports transaction processsing. Just do
not know whow long this app will actually live in it's current state -
hence thinking about adding some Xaction processing to existing app...
Thanks,
Brad
.
- References:
- Access and transaction processing...
- From: Brad Pears
- Re: Access and transaction processing...
- From: Allen Browne
- Access and transaction processing...
- Prev by Date: Re: Access 2007 Technical Questions
- Next by Date: Re: System variable
- Previous by thread: Re: Access and transaction processing...
- Next by thread: Re: Access and transaction processing...
- Index(es):
Relevant Pages
|
