[RESOLVED] ms access- showing who has an ldb open

does anyone knows how to list and "kill" open users in access (according to ldb files)

I'm sure this was done here before, but somehow I can't seem to find it.

thanks,

You may be able to read the.ldb file since it lists the machine name and user name for each user that has the db open.

do I open it as an access database? do you have any vba example or a link?

The .ldb file is nothing more then a text file. Usebasic File I/O.

Thanks a lot, just what I wanted to hear!

You may come upon issues with formatting of the ldb file. I think there is another method for this. I remember something using Access Object Model to determine users or connections. If you have any trouble let me know and I'll look into it more.