DAO 3.6 record locking

Hello,

I want to lock users' password records after they log on to a VB6
application. I want to be able to determine who is logged on to the
database by polling each password record to see if it is locked or not.
(DBF files allowed this sort of locking and checking to see who was logged
on at a given moment.) Can DAO 3.6 do this? It seems the new record-level
locking is not under programmer control, except on a global record-level vs
page-level basis when edits are happening.

Thanks,
Allen Anderson

On Thu, 17 Feb 2005 21:12:24 GMT, "Allen Anderson"
<allenanderson.RemoveThis@mindspring.com> wrote:

 >I want to lock users' password records after they log on to a VB6
 >application. I want to be able to determine who is logged on to the
 >database by polling each password record to see if it is locked or not.
 >(DBF files allowed this sort of locking and checking to see who was logged
 >on at a given moment.) Can DAO 3.6 do this? It seems the new record-level
 >locking is not under programmer control, except on a global record-level vs
 >page-level basis when edits are happening.

How about adding an additional field to your password record table,
say [LockTimeStamp]... have your application(s) set the timestamp
immediately upon login and again every n minutes.

You may have some false positives if they fail to log out and clear
the field, but otherwise you would have some idea of the number of
connections. And you could write a process that would reset/clear
entries that are older than (n * 2) minutes.
_______________________
Michael B. Johnson<!-- ~MESSAGE_AFTER~ -->