Users Logged In Lock Files 2

[Rachel30]

Hi,

Does anyone know if you have an ms access database on the server and there is a lock file which means there are users in the system, how I can tell which users are in the sytem.

Thanks Rachel.

 

[dhookom]

Open the lock file (___.ldb) with NotePad.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PPJOSEPH]

Great answer dhookom. I always thought how can I tell. I tried the codes for ShowUser but did not work. You deserve a star even if I did not ask the question. Do you know if it works if there are than one user logged in at the same time.
Paul

 

[PPJOSEPH]

I meant to ask, Do you know if it works if there are more than one user logged in at the same time?

 

[dhookom]

The "back-end" ldb file should display all current users.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[LittleSmudge]

Well isn't that interesting.

I have this half a page of code that interogates the Security.MDW file to see whos logged in - but that still doesn't tell me which one of the many databases using the same Security.mdw file they are logged in to.

Yet the simplest text editor cracks open the .LDB file and reviels the user(s) at the specific database level.


Nice one dhookom




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[Rachel30]

Thanks for your help. I have had a look at the backend ldb file. I did know that I could open them in notepad.

We have upto 10 users who go into the database at any one time although the file shows all the users in it does not show when they exit out of the system. The problem I have is when I send an updated mdb to the server I ask all the users to exit out of the db and there is allways someone who forgets and I need to find out who that person is. The lock file shows everyone who logged on but does not delete there name when they logg of.

Cheers Rachel.

 

[dhookom]

I noticed the user reference is not removed when they exit. Check

http://support.microsoft.com/kb/299373/EN-US/.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MoLaker]

You might want to consider obtaining Microsoft's ldbview.exe. (

http://support.microsoft.com/default.aspx?scid=kb;en-us;176670)

Although viewing with Notepad works, it can fool you sometimes. If one or more users have the database open, the ldb file continues to exist. As long as it exists, usernames that were logged in, but have since logged out, remain listed in the ldb file. These inactive names are removed only when the database is closed by everyone and the ldb file is deleted. When the database is opened again and the ldb file re-created, it will start it's list all over again. Ldbview will give you an indication of whether the connection is active or not.

Ldbview will work with Jet 2.x and Jet 3.x, but I'm not sure about Jet 4.x.