myODBC, if left alone, can lock up an Access table

[Steve Quezadas]

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. Anyone know of a work-around? I can replicate this problem across two different machines.

Anyone know of this problem?

- Steve



---------------------------------------------------------------------
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