Re: cancelling upon delete or update does not work with MS Access 2003

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

RAPPAZ Francois wrote:
> Hi
> when I run an update query or a delete query in the query window of MS-Access 
> 2003 SP1, I'm asked "n rows will be deleted/updated if you say yes". The 
> problem is that if I say no, the action is still executed and the rows are 
> changed.
> 
> The same occurs if in a form I delete a reccord: selecting cancel does not 
> change anything !
> 
> This is annoying, you don't have a chance to correct a mistake. Is this a 
> problem on the Access side or on the mysql odbc driver (3.51.12)?
> 
> Thanks for any comments

Access goes ahead and actually deletes or updates the rows, and issues a
rollback if you cancel. If you use a transactional storage engine like
InnoDB for your tables, this will work as expected.

I'm not going to pass judgment on whether or not this is a faulty way to
do things (Access could actually hold off on issuing the query before
you answer the dialog).

        -Mark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEWLU4tvXNTca6JD8RAlACAJ4/VaTfainIVQqP0xLjUN3Wy9F+vgCgkgTa
os2tmKY2x/vW5tmqMIzLqBY=
=993/
-----END PGP SIGNATURE-----

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx