Many thanks to [EMAIL PROTECTED] for a work around to my
question, here is the reply - as he/she cannot post to the list as their
email server adds an attachment, preventing the post. Thanks again, John.
---------------------------
Yes, I have had the same problem.
>From what I can tell, the issue is caused by excessive periods of
inactivity. I don not believe the connection is being dropped from the
server, it appears to be the Access client that is dropping the
connection. The work around that we have applied here, is that we poll
the server every five minutes to verify its still available. This
query is a very simple, low overhead type of thing that is run from
code from the main menu's timer function. Just enough activity to keep
the ODBC connection alive. We use them to have the client check for
system messages that we present to the user. Things like "System
Maintenance required, please log out now."
Something to note, is that Msg Boxes and Input Boxes on the screen seam
to prevent any and all code from running. So they can break this work
around.
One last thing, my mail server insists upon including an attachment
with my email, winmail.dat. It contains header information from the
mail message and we can't get rid of it. Anyway, that attachment
prevents me from posting messages to mailing list. Would you please be
so kind as to remove that attachment and forward this message to the
list for me?
Thanks,
[EMAIL PROTECTED]
-----Original Message-----
From: mysql-digest-help [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 3:44 PM
To: mysql
Cc: johnlucas
Subject: MS Access Links to Mysql
Hello again folks
I am using MS Access as the front end to my database, but after a while
of
use, I get a prompt as follows, when I try to close a table in datasheet
view or when I try to close a form:
"The action will reset the current code in break mode {blah blah blah}"
Then I have to choose yes or no.
(I don't have any VBA code running that could be halted anyway when this
happens)
Either way this doesn't close the object I have open and I have to
resort to
killing the application from the task manager.
Does anyone else have the same problem?, anyone have any ideas of how I
can
overcome it?
Thanks for any help.
John.
---------------------------------------------------------------------
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
