Simple yet complicated

[JohnD]

I have searched and tried previous examples to only fail in this process.

We have a database that is accessed by over 20 employees at one time and virtually every day we run into the same problem. Someone is trying to edit a record but can not do this due to another user being logged into that specific record. Not knowing who is in the record burns valuable working time trying to hunt down the individual and getting them to filter out of the record so it can be edited by the other user.

To eliminate this pointless search, I would like to create a simple box in the form that displays who is logged into that specific record (if any). That way we know exactly who is in that specific record and we can call them directly.

I have attempted the many examples in the searches of this forum but it may have to do with my lack of knowledge working with Modules or Expressions. Current User only displays your own user ID making it useless in this case.

Any help is greatly appreciated!
John

 

[seth_belgium]

You could store the recordID and the userID in a separate table. Each time a user opens a record, you add both recordID and userID to that table. When the user exits the record you can delete that line from the table.

That way you can always have an overview of who is accessing what data.

But it's possible there's another way, maybe someone else could take a look at this?

Greetz,

Seth

 

[JohnD]

That would certainly cause me a headache if I have to do that manually.

All and all, we just need to identify the user in the record and have that be displayed in the form so that other users may know who to contact within our agency.

(We are using Windows 2000 and Access 97) if that makes a difference in the solution.

There other routes to this?

 

[seth_belgium]

You can automate this process, you know...

 

[JohnD]

...Precisely why I have just purchased two books on Access...