Display user who has record locked in Access 2000/2002

[RonMck1]

Within the application we are using, users are running into issues where records are beeing locked and they have no idea who it is. They must go to other units to have the person save the record.

In the 97 version, you could display a message box that user has the record locked.

in 2000/2002, this doesn't seem to be the case. It just states that the record is locked.

The application is using the jet security, how can we display the user who has the record locked (posibly without adding another field in the tables to track)


Any info would be appreciated.


Ron

 

[Page410]

If you do a search for LDB Viewer, you will find your solution.

Here is the link to the first result returned by a Yahoo search.

http://www.mvps.org/access/modules/mdl0055.htm

Good luck

 

[RonMck1]

Thank's for the info, though this will only tell me who logged on.

What I need is info on how to determine wich user has a record locked (as for the application uses an edit button) and display the users name on the screen for the user who is trying to access the locked record.

Something like John Doe has the record locked at this time.

Access 97 had this feature (VBA), though seems to of lost it with newer versions of access.

Ron

 

[Hap007]

Dear Ron,

I suspect that if you include DAO in your VBA code references, then your lock code will probably function as it did in Access97.

Just a Guess though,
Hap

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/groups/accessDevelopers