Cannot Log Off and Close *.ldb File

[EarlCPhillips]

I am the primary programmer on the Volunteer System at Harvesters. I cannot
gain exclusive access to the main program to install new changes as of today.
I had everyone sign off and I also did the same. I even stopped my PC in an
attempt to close the Volunteer.ldb file. I tried signing on and using
Tools/Database Utilities/Compact and Repair Database, but it tells me that
someone at my PC's networkID location is signed on at my PC ID other than
myself. Still the Volunteer.ldb file remains on the server where all
programs and data are located.

The programs and data are split and both reside on the server and all
activity occurs over the network. Noone has Volunteer.mdb on their PC. Why
can't I sign-off when noone else is signed on and have it remove the
Volunteer.ldb and Data.ldb files?

EarlCPhillips
Ex-mainframer Learning Access to
Help Feed the Hungry in Kansas City at
Harvesters Community Food Network

 

[JvC]

Earl,

Shut down the server the database is on and restart it. That will take
care of the ldb file.

John

EarlCPhillips has brought this to us :

 

[boblarson]

If everyone is out of it and the file remains that usually means that someone
doesn't have the appropriate delete rights on that folder where the database
files reside. I would check into that to fix that problem.

Then, JvC mentions restarting the server, but that is not always an option
in a high utilization environment. So, as long as everyone is out of the
database and you have delete rights on that server, you should be able to
delete the ldb files manually.

But, make sure everyone who needs to use the database has READ/WRITE/DELETE
rights on that folder where the database resides.
--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________