.ldb refresh?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a function that reads the contents of a database's .ldb file, and
lists them for selection for a NET SEND message. The only problem is that
..ldb files don't always update right away when someone logs off.

Is there a way in VBA code to tell an .mdb file, "Hey, go update your .ldb
file NOW" ?

Thanks!
 
Bill said:
I have a function that reads the contents of a database's .ldb file,
and lists them for selection for a NET SEND message. The only problem
is that .ldb files don't always update right away when someone logs
off.

Is there a way in VBA code to tell an .mdb file, "Hey, go update your
.ldb file NOW" ?
Click to expand...

Are you just looking at the raw entries in the .ldb, or are you checking
the flag that tells whether a particular entry is in use? As I
understand it, the user "slots" in an .ldb file aren't removed when the
user logs out, and the .ldb file doesn't shrink. Unused slots are just
marked as such.

I've never fooled around with this, but you may want to review this web
page:

http://www.mvps.org/access/general/gen0034.htm
 
Bill said:
I have a function that reads the contents of a database's .ldb file,
and lists them for selection for a NET SEND message. The only problem
is that .ldb files don't always update right away when someone logs
off.

Is there a way in VBA code to tell an .mdb file, "Hey, go update your
.ldb file NOW" ?

Thanks!
Click to expand...

There is an LDB viewer that you can download from Microsoft. Any time you
examine the file without that you will see all users who have been in the file
since the LDB was created. All you can determine from that is that at least one
of the users you see is still using the file because users are not removed when
they leave the file.
 
Back
Top