|  | Cannot Log Off and Close *.ldb File | | |
| | | EarlCPhillips |  |
|  Posted: Mon Sep 22, 2008 4:25 pm Post subject: Cannot Log Off and Close *.ldb File |  |
| |  | |
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
--
Trying To Feed The Hungry |
| |
| | | JvC | |
| | Posted: Mon Sep 22, 2008 5:03 pm Post subject: Re: Cannot Log Off and Close *.ldb File | |
| | | |
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 :
| Quote: | 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 |
|
| |
| | | boblarson | |
| | Posted: Mon Sep 22, 2008 7:50 pm Post subject: RE: Cannot Log Off and Close *.ldb File | |
| | | |
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 LINK
__________________________________
"EarlCPhillips" wrote:
| Quote: | 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
--
Trying To Feed The Hungry |
|
| |
|
|
