MS Access 'SafeTransactions' flag?

Jason Wallenfang -- poozer@mindspring.com
Wednesday, March 05, 1997

Environment: Windows 95, NT 4.0, VC++ 4.2b

I am wondering if the SafeTransactions parameter is concurrency based
or is the equivelant to "SERIALIZABLE" transaction isolation level.

I guess that what I am looking for an answer on is:  Does MS Access
95/97 allow for complete transaction isolation?  This would be
accomplished through a TIL of Serializable but it would seem that MS
Access does not support any TIL settings above READ COMMITTED.  I
really would like to enforce complete transaction isolation without
using record locking and allow the database to resolve the effects of
multiple transactions on a single/multiple records in the database.

Thank you,
Jason Wallenfang
poozer@mindspring.com
jwallen@campbellsoft.com

---

Mike Blaszczak -- mikeblas@nwlink.com
Friday, March 07, 1997

At 22:52 3/5/97 -0600, you wrote:
>Environment: Windows 95, NT 4.0, VC++ 4.2b

>I am wondering if the SafeTransactions parameter is concurrency based
>or is the equivelant to "SERIALIZABLE" transaction isolation level.

>I guess that what I am looking for an answer on is:  Does MS Access
>95/97 allow for complete transaction isolation?  This would be
>accomplished through a TIL of Serializable but it would seem that MS
>Access does not support any TIL settings above READ COMMITTED.  I
>really would like to enforce complete transaction isolation without
>using record locking and allow the database to resolve the effects of
>multiple transactions on a single/multiple records in the database.

This question doesn't have anything to do with MFC.  Perhaps you should
ask on an Access-specific mailing list or newsgroup, like
news:comp.databases.ms-access.


.B ekiM
http://www.nwlink.com/~mikeblas/
These words are my own. I do not speak on behalf of Microsoft.
           This performance was not lip-synched.

---

Become an MFC-L member | Вернуться в корень Архива |