Re: Could not lock file



"Ron Kunce" <AID9F5C@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23VeuNw1RFHA.2252@xxxxxxxxxxxxxxxxxxxxxxx
>I have a lot of users getting a warning message -2147467259, "Could not
>lock
> file". The error handler routine sending the warning, comes from one of
> several functions which are NOT doing any kind of update process. However
> these function's are launched from a timer function to compare records in
> a
> local and fileserver based databases (.mdb's).

Try going through a few of these.... there aren't that many. Hopefully,
something will look familiar.

Results 1 - 15 of about 32 for "Could not lock file" -dotnet group:*.vb.*.
(5.21 seconds)
http://groups.google.co.uk/groups?as_epq=Could%20not%20lock%20file&as_eq=dotnet&safe=images&as_ugroup=*.vb.*&as_scoring=d&lr=&num=100&hl=en

> How can a function, not performing an update, issue a file lock warning?
>
> Can the VB timer function be running separate threads, so that when an
> update process running somewhere else cause a warning to be issued from
> within a different function?

No.. Timers don't run on their own thread. Here's a snip I post once in a
while that describes how events work......

'===========
Timer events are not asynchronous. Events merly change the programs "current
instruction pointer" temporarily. It doesn't get changed back until the 'End
Sub' runs in the event handler.

Example based on a Timer event....

Private Sub ABC()
1 code here
2 code here
3 code here
'timer event fires after running line 3
'code in timer's event handler starts
4 code here
5 code here
6 code here
End Sub

Private Sub Timer1_Timer()
'This entire procedure runs before
'returning to line 4 above
'it will never return until the line below runs
End Sub


--
Ken Halter - MS-MVP-VB - http://www.vbsight.com
Sign up now to help keep VB support alive - http://classicvb.org/petition
Please keep all discussions in the groups..


.



Relevant Pages

  • RE: Timed and blinking messages
    ... the Warning macro will loop endlessly. ... Private Sub UserForm_Click ... Do While Timer < Delay ...
    (microsoft.public.excel.programming)
  • RE: Timed and blinking messages
    ... Warning procedure that is located in the Userform code as well. ... Private Sub UserForm_Click ... Do While Timer < Delay ...
    (microsoft.public.excel.programming)
  • RE: I cant figure out how to solve this problem.
    ... Main in turn adds a handler for the timer. ... You might try moving the loop code to its own sub and calling that sub from ... > Public Sub TimerEventProcessor(ByVal myObject As Object, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Could not lock file
    ... Private Sub Timer1_Timer ... >I have a lot of users getting a warning message -2147467259, ... > these function's are launched from a timer function to compare records in ...
    (microsoft.public.vb.controls)
  • [PATCH 5/6] ide: checkpatch.pl fixes for ide-iops.c
    ... WARNING: space prohibited between function name and open parenthesis '(' ... -void ide_fixstring (u8 *s, const int bytecount, const int byteswap) ... * and we have not yet hit our maximum waiting time, then the timer is restarted ... * every 50ms during an atapi drive reset operation. ...
    (Linux-Kernel)