Re: Microsoft Access and Transaction Isolation Level
- From: "Daniel Crichton" <msnews@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 11 Nov 2005 10:12:59 -0000
Kevin wrote on Fri, 11 Nov 2005 08:01:01 GMT:
> Yes, Access itself doesn't support transaction. However, you can enable
> trasaction with Jet OleDb.
The Jet engine itself does support transactions - a quick search on the MS
Support site is enough to prove this. However, it does require explicit
starting as Jet does not automatically start transactions. You can use
transactions in an Access query (using BEGIN TRANSACTION and COMMIT or
ROLLBACK) - try it :)
Dan
.
- References:
- RE: Microsoft Access and Transaction Isolation Level
- From: Kevin Yu [MSFT]
- Re: Microsoft Access and Transaction Isolation Level
- From: Daniel Crichton
- Re: Microsoft Access and Transaction Isolation Level
- From: Kevin Yu [MSFT]
- RE: Microsoft Access and Transaction Isolation Level
- Prev by Date: Unable to open Excel file in read-only if file already open by another user
- Next by Date: Re: Unable to open Excel file in read-only if file already open by another user
- Previous by thread: Re: Microsoft Access and Transaction Isolation Level
- Next by thread: Re: Microsoft Access and Transaction Isolation Level
- Index(es):
Relevant Pages
|
|
