We are using an Access 2000 app on a Citrix server with Windows 2000. There
are between 3 and 12 people using it in a typical day. I've noticed that
when everybody has closed their apps (at least in theory) the ldb file is
still there, it cannot be deleted, and the application cannot be edited in
any way. Usually, after rebooting the server, this file can be erased
(sometimes it cannot be erased). ALso, the application can be edited.
What does this file do ?
Should it always be closed automatically when the last user exits the
application. Eg, is Access that smart to be able to figure out to close it?
Finally, is there a way to know when the last user is exiting? I'd like to
do a compact and repair on the back end data mdb.
Many thanks
Mike Thomas