I am experiencing problems with record locking on database updates.
When I use an Access update query to modify a record subsequent updates
to the same records result an Access 97 message stating that the record
is in use by another user. This happens if I am the sole user of the
database. It would appear that the MySQL server is not releasing it's
table locks correctly after an Access update query.
Unfortunately I am unable to pin down which component is the source of
the problem; MyODBC, Access97 or a MySQL servere misconfiguration.
Software: MySQL server v3.22.21 o/s: SGI IRIX v6.5.9
MyODBC v2.50.36 MS Windows 95
MS Access 97 MS Windows 95
Grateful for any help you can offer.
Thanks.
--
Paul Will
Daewoo Worthing Technical Centre
Tel: 01903 227132
Fax: 01903 227212
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
