Posted by Manuel Lemos on 08/14/05 22:58

Hello,

on 08/13/2005 09:16 PM Pablo Gosse said the following:
> I have the unfortunate task of writing a PHP front-end for a
> client-server application that is back-ended in MS Access.
>
> I've tried using the transaction functionality in ADOdb (PHP
> implementation of ADO) but it doesn't work seem to work correctly, even
> though it says it does.
>
> If I intentionally submit a malformed query as part of a series of
> inserts, the ADOdb transaction supposedly rolls back, but when I look at
> the database, the inserts carried out before the error occurs are still
> there.
>
> Does anyone know if it's possible to use transactions with Access via
> PHP?

Yes, the Metabase driver for MS Access via ODBC implements transaction
support:

http://www.phpclasses.org/metabase


--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html

[Back to original message]