hi,Search back through the archives of this list and the MyODBC list.
access-2000 w2k-prof/xp-prof via myodbc 3.51 different mysql-servers (win-lin)
if i leave ms-access longer than 25 minutes alone with mysql via myodbc 3.51
i cannot close ms-access:
- free translation:
"this procedure will put the current code back into the interruption mode. would you like to stop the execution of the code?"
- german-original: "dieser vorgang wird den aktuellen code in den unterbrechungsmodus zuruecksetzen. moechten sie die ausfuehrung des codes anhalten?"
i have to kill ms-access with the task-manager!
after 24 minutes, no problems.
my preferred solution would be: $killall -9 access.exe #rpm -e ms-office #rpm -e windows
is this a known problem with myodbc? access?
how can i prevent this?
The short answer is that Access is f**ked and will crash when left unattended.
I had originally thought that it only affected Access 2002, as Venu couldn't reproduce my problem under Access 2000. But apparently not.
One dodgy fix which I've considered but not used is to have a hidden form with a timer event which opens an ADO connection to MySQL and closes it every 3 minutes. I haven't tested it but since the problem only happens when there is no activity between Access and MySQL, I assume this will work. Personally I prefer to leave it as is and tell everybody to direct their complains to [EMAIL PROTECTED]
I would _strongly_ recommend that if you are working on an original database that you close it before walking off to get a coffee. I have lost almost a full day's work on several occassions because of this.
If you can be bothered, maybe turn on ODBC logging and send a log in to the MyODBC list. However I'm pretty sure the problem is with Access and not MySQL / MyODBC. Maybe it's even intended...
-- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com
--------------------------------------------------------------------- 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
