>>

if rlock('0','mytable') then
>>   insert into mytable values (value1, value2)
>>   unlock record 0 in mytable
>>else
>>   * you can't log in right now, try again
>>endif

>>
>>You could put this in a loop with a counter or you could bump up reprocess so VFP internally runs its own loop and counter.
>
>It is the 'You can't log in right now...' portion that is the problem. The user needs to log in 100% of the time. So I can put it in a loop, but what I want to make sure of is that they get logged in. How about:
>
>DO WHILE NOT rlock('0','mytable')
> insert into mytable values (value1, value2)
> unlock record 0 in mytable
> EXIT
>ENDDO

Fine if you put a counter in there or a timer. What if something has gone horribly wrong? They get stuck in your loop forever.

Jeff