By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,030 Members | 1,997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,030 IT Pros & Developers. It's quick & easy.

Problem saving memo field using timer

P: n/a
In A2000 I have a table containing a memo field. There is an unbound
form for entering text, and there can be lots of it. When the form
opens there is a function to grab the data from the table and enter it
into the field. There is another function to save the data back to the
table. There is also a timer running to save the data every 10 seconds.

All works well except very occasionally, especially when there is a lot
of data, the user gets an error 3118, 'Could not update; currently
blocked out by another session on this machine'.

It doesn't happen often and has been difficult to diagnose, but I have
worked out that it appears to only happen if the user is typing at the
point where the timer triggers the save function. Once it has occurred,
it seems to leave the data somehow corrupted and the error message
reapppears every 10 seconds, even if they close the form and re-open
it.

I would be grateful for any information about this, and how to solve
it, apart from removing the timer !!

For example, is there a way I could do the save only if there was no
keyboard activity.

Thanks for your help
Dave

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.