Hi all, I want macro in excel which should check Microsoft Access
"mdb" file in specified folder that if it is open or not and also is
it possible to check that file is opened by which user. I know I can
check this in excel by WriteReversedBy command but how can i check
that which user has opened the mdb file. Please help

On 24 dec, 11:17, K <kamranr1...@yahoo.co.uk> wrote:
> Hi all, *I want macro in excel which should check Microsoft Access
> "mdb" file in specified folder that if it is open or not and also is
> it possible to check that file is opened by which user. I know I can
> check this in excel by WriteReversedBy command but how can i check
> that which user has opened the mdb file. *Please help

Hi K,

As soon as an Access file is in use by someone next to the mdb you
will see a ldb file.
This file contains Record-Locing Information.
For each user an entry will be added and removed according to start
and stop using the mdb.
Unfortunately there is not a clear separation for each active user you
will have to split the line(s) with information at 64 characters.

HTH,

Wouter

On Dec 24, 10:58*am, RadarEye <wouter.ma...@sogeti.nl> wrote:
> On 24 dec, 11:17, K <kamranr1...@yahoo.co.uk> wrote:
>
> > Hi all, *I want macro in excel which should check Microsoft Access
> > "mdb" file in specified folder that if it is open or not and also is
> > it possible to check that file is opened by which user. I know I can
> > check this in excel by WriteReversedBy command but how can i check
> > that which user has opened the mdb file. *Please help
>
> Hi K,
>
> As soon as an Access file is in use by someone next to the mdb you
> will see a ldb file.
> This file contains Record-Locing Information.
> For each user an entry will be added and removed according to start
> and stop using the mdb.
> Unfortunately there is not a clear separation for each active user you
> will have to split the line(s) with information at 64 characters.
>
> HTH,
>
> Wouter

Thanks for replying Radar, do i need to open ldb file in notepad to
see the result