Thomas Trutt wrote: > Hello all... > > And thanks ahead of time for the help... > > I'm having an issue with a locked table... > > I have about 27 tables in MySQL Db that i am working with with > multiple MS Access front ends.. The problem is one of my tables is > locked, but only the first 400 records, the rest is fine... Any idea > on how to unlock it???
In the medium to long-term, don't use MS Access :) In the short term, you can convert the tables being locked to InnoDB, which seems to give you somewhat of a grace period before. This saved me on more than 1 occasion while I ported our legacy Access apps. If you know some Perl, you can always use something like: http://entropy.homelinux.org/axis_not_evil -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]