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

**bambo** · Jan 12th, 2006, 07:26 PM

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,

**RobDog888** · Jan 13th, 2006, 02:42 AM

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.

**bambo** · Jan 13th, 2006, 05:05 AM

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

**RobDog888** · Jan 13th, 2006, 11:07 AM

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

**bambo** · Jan 13th, 2006, 11:21 AM

Thanks a lot, just what I wanted to hear!

**RobDog888** · Jan 13th, 2006, 02:44 PM

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.

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

Thread Tools

Display

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

Re: ms access- showing who has an ldb open

Re: ms access- showing who has an ldb open

Re: ms access- showing who has an ldb open

Re: ms access- showing who has an ldb open

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

Posting Permissions