Check if mdb file is open


K

K

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
 
Ad

Advertisements

R

RadarEye

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
 
Ad

Advertisements

K

K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top