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

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


Fran=E7ois Rappaz

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

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

-----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+vgCg kgTa
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@m.gmane.org