Locked Records

[Pietro]

Hi,
I've a database that opens to a form called 'Login' that asks users to
input the user name and password...
Everything is going well,my only problem is that i set the form property
'Record locks' to 'edited record'
As I've many users it may happen that a record is locked and we don't
know who locked it,can I have a code that shows me who's locking the record
at the time being so as not to spend much time looking for him...
I need to add a field to the table on which is form is bases,i need
this field to reflect the value [forms]![login]![agent] as this is the hidden
form that diffrentiate between users...

 

[Jerry Whittle]

If you would use the built-in security tools instead of re-inventing the
wheel, you wouldn't have such problems.

 

[Pietro]

Ok,but the security tools has several problems;
* Users cannot change their passwords.
* If the program is transferred from PC to the other, the security tools
will not work.
* I need to get other benefits from the invented ones that cannot be
obtained through theb security tools.

Can you help?

If you would use the built-in security tools instead of re-inventing the
wheel, you wouldn't have such problems.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hi,
I've a database that opens to a form called 'Login' that asks users to
input the user name and password...
Everything is going well,my only problem is that i set the form property
'Record locks' to 'edited record'
As I've many users it may happen that a record is locked and we don't
know who locked it,can I have a code that shows me who's locking the record
at the time being so as not to spend much time looking for him...
I need to add a field to the table on which is form is bases,i need
this field to reflect the value [forms]![login]![agent] as this is the hidden
form that diffrentiate between users...