> -----Original Message----- > From: Steve Quezadas [mailto:[EMAIL PROTECTED]]
> I notice that sometimes when I establish a connection with > myODBC with > Microsoft Access, and send it occasional sql statements it > works fine at > first. But if you let it sit for, say, 30 minutes and comes back, the > Access table locks up. I am not sure if this is a problem with myODBC > (which I would report to this mailling list) or a problem with Access > itself (thus I would have to report it to the Access > newsgroup). Anyways, > this problem is kinda annoying because the only way I can get > out of it > is if I force-quit Access. I haven't seen this problem. The only time I've had to force-quit Access was if I changed a table definition or restarted MySQL while Access was open -- this tends to put it in an infinite loop. (Great error handling, Microsoft!) Maybe someone can help you out more of you provide more details of your setup? MySQL, MyODBC, and Access versions, operating system of the clients, etc. Linked tables, or direct access via VBA? Anything else unusual? FWIW, we're using Windows NT 4.0, Access 2000, and MyODBC 2.50.39. We're using linked tables. We haven't had any problems that weren't covered by the MyODBC FAQ. I highly recommend following their recommendation of adding a TIMESTAMP column to each table, it fixed the flakiness we were having with disappearing records and locked tables. --------------------------------------------------------------------- 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
