Delete LDB file John 05.06.2006 14:33:01 I have a persistent ldb file I need to get rid of. I am the only user, the LDBViewer shows it's ME logged in but I have cold booted my system, resynced folders, there's no one using the .mdb and yet the ldb file won't go away. How can I get rid of it?

Re: Delete LDB file "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro[ at ]Spameater.orgZERO_SPAM> 05.06.2006 19:50:26 Hi, John. [Quoted Text] >I have a persistent ldb file I need to get rid of. I am the only user Ensure that you have Windows security permissions to delete files in the directory where the Access database file is located. Is this file is located on your workstation or on the network? If it's on the network, what operating system are you using and what operating system is the network server using? I ask because settings on the network server may be interfering, or your operating system may handle network requests a little differently than usual. > I have cold booted my system, resynced > folders What exactly are you doing to resync the directories? Copying files, their attributes, and their Windws security permissions so that both directories match precisely? Does this task accidentally copy an errant .LDB file to the other matching directory? HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. "John" <John[ at ]discussions.microsoft.com> wrote in message news:587DACF4-4D98-455C-A3F1-CEA4D9ED886F[ at ]microsoft.com... >I have a persistent ldb file I need to get rid of. I am the only user, the > LDBViewer shows it's ME logged in but I have cold booted my system, > resynced > folders, there's no one using the .mdb and yet the ldb file won't go away. > How can I get rid of it?

Re: Delete LDB file John 06.06.2006 18:12:07 In Line: "'69 Camaro" wrote: [Quoted Text] > Hi, John. > > >I have a persistent ldb file I need to get rid of. I am the only user > > Ensure that you have Windows security permissions to delete files in the > directory where the Access database file is located. I do have permissions verified by successfully deleting a file in the same folder. > Is This file located on your workstation or on the network? On the network >If it's on the network, what operating system are you using and what operating system is the network server using? Running Windows 2000 on local... don't know what the network is running. >I ask because settings on the network server may be > interfering, or your operating system may handle network requests a little > differently than usual. > > > I have cold booted my system, resynced > > folders > > What exactly are you doing to resync the directories? Copying files, their > attributes, and their Windws security permissions so that both directories > match precisely? The system was set up before I got here (contractor) and uses Win2k syncronization. Not sure how it works but it supposedly syncronizes the local with the network??? >Does this task accidentally copy an errant .LDB file to the other matching directory? We have had multiple network outages and there may have been times when the network came back up and asked about saving files, etc. the wrong answer was given so perhaps the .ldb file that was on the server was not deleted even though the application on the local was not running. This is where I think the problem lies....somehow.... Guess the question is... how can I delete the .ldb file? Gunny?? as in Sarg? > > HTH. > Gunny > > See http://www.QBuilt.com for all your database needs. > See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. > http://www.Access.QBuilt.com/html/expert_contributors2.html for contact > info. > > > "John" <John[ at ]discussions.microsoft.com> wrote in message > news:587DACF4-4D98-455C-A3F1-CEA4D9ED886F[ at ]microsoft.com... > >I have a persistent ldb file I need to get rid of. I am the only user, the > > LDBViewer shows it's ME logged in but I have cold booted my system, > > resynced > > folders, there's no one using the .mdb and yet the ldb file won't go away. > > How can I get rid of it? > > >

Re: Delete LDB file Andy <hiestand[ at ]kgexpress.net> 07.06.2006 01:21:26 Hmmm...Win2K server, msAccess, locked up ldb files. Sounds familiar. Unfortunately, I do not have a great answer for you, but I have seen this on our server more times than I would like to have. I remove all (windows) permissions on the ldb file for everyone except me. On my system, I have to wait about an hour before the system realizes that no one is really using the file, and then delete the file. hth, Andy

Re: Delete LDB file "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro[ at ]Spameater.orgZERO_SPAM> 07.06.2006 06:15:42 Hi, John. [Quoted Text] >>If it's on the network, what operating system are you using and what >>operating system is the network server using? > Running Windows 2000 on local... don't know what the network is running. Ensure that opportunistic locks are disabled. Windows 2000 Server is the most common culprit, but other operating systems have this feature, too. For more information, please see the following Web page: http://support.microsoft.com/default.aspx?id=296264 > The system was set up before I got here (contractor) and uses Win2k > syncronization. Not sure how it works but it supposedly syncronizes the > local > with the network??? I'm not familiar with this, so I can't comment on it. > We have had multiple network outages Access databases don't do well on a flaky network. It often leads to corrupted database files. > network came back up and asked about saving files, etc. the wrong answer > was > given so perhaps the .ldb file that was on the server was not deleted even > though the application on the local was not running. This is where I think > the problem lies....somehow.... The Windows network administrator has tools that can show him which workstation has a networked file locked. Perhaps its time to do some sleuthing. If you can find out which workstation has the file locked, it may lead to finding out how to prevent it from happening. > Guess the question is... how can I delete the .ldb file? If you can't delete it yourself though you have sufficient permissions to do so (and it sounds like you do), have the Windows network administrator break the lock on the file and delete the file for you. > Gunny?? as in Sarg? No. Gunny, as in "Gunnery Sergeant, United States Marine Corps." Army dogs with three or more stripes are called Sarge. No Marine would suffer lightly the indignity of being called Sarge, and no Marine who has earned at least one rocker will answer to the name of Sergeant, because there's a huge difference between the Staff NCO ranks and the NCO and non-NCO ranks. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. "John" <John[ at ]discussions.microsoft.com> wrote in message news:10E1047F-F0A5-44F5-A08B-E769CDCC4D99[ at ]microsoft.com... > In Line: > > "'69 Camaro" wrote: > >> Hi, John. >> >> >I have a persistent ldb file I need to get rid of. I am the only user >> >> Ensure that you have Windows security permissions to delete files in the >> directory where the Access database file is located. > > I do have permissions verified by successfully deleting a file in the same > folder. > >> Is This file located on your workstation or on the network? > > On the network > >>If it's on the network, what operating system are you using and what >>operating system is the network server using? > Running Windows 2000 on local... don't know what the network is running. > >>I ask because settings on the network server may be >> interfering, or your operating system may handle network requests a >> little >> differently than usual. >> >> > I have cold booted my system, resynced >> > folders >> >> What exactly are you doing to resync the directories? Copying files, >> their >> attributes, and their Windws security permissions so that both >> directories >> match precisely? > > The system was set up before I got here (contractor) and uses Win2k > syncronization. Not sure how it works but it supposedly syncronizes the > local > with the network??? > >>Does this task accidentally copy an errant .LDB file to the other >>matching directory? > > We have had multiple network outages and there may have been times when > the > network came back up and asked about saving files, etc. the wrong answer > was > given so perhaps the .ldb file that was on the server was not deleted even > though the application on the local was not running. This is where I think > the problem lies....somehow.... > > Guess the question is... how can I delete the .ldb file? > > Gunny?? as in Sarg? > >> >> HTH. >> Gunny >> >> See http://www.QBuilt.com for all your database needs. >> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. >> http://www.Access.QBuilt.com/html/expert_contributors2.html for contact >> info. >> >> >> "John" <John[ at ]discussions.microsoft.com> wrote in message >> news:587DACF4-4D98-455C-A3F1-CEA4D9ED886F[ at ]microsoft.com... >> >I have a persistent ldb file I need to get rid of. I am the only user, >> >the >> > LDBViewer shows it's ME logged in but I have cold booted my system, >> > resynced >> > folders, there's no one using the .mdb and yet the ldb file won't go >> > away. >> > How can I get rid of it? >> >> >>

Re: Delete LDB file "david epsom dot com dot au" <david[ at ]epsomdotcomdotau> 07.06.2006 07:49:00 I've seen this happen with compressed files, so I'm guessing it could happen with synchronised files as well: Explorer and Windows have asynchronous access to NTFS, and sometimes NTFS is still trying to do something to the file long after Windows and Windows Explorer have finished. I don't know how to abort asynchronous NTFS operations: they continue if you shut down and re-start. BTW, If you are using a compressed folder, you probably shouldn't. (david) "John" <John[ at ]discussions.microsoft.com> wrote in message news:10E1047F-F0A5-44F5-A08B-E769CDCC4D99[ at ]microsoft.com... [Quoted Text] > In Line: > > "'69 Camaro" wrote: > >> Hi, John. >> >> >I have a persistent ldb file I need to get rid of. I am the only user >> >> Ensure that you have Windows security permissions to delete files in the >> directory where the Access database file is located. > > I do have permissions verified by successfully deleting a file in the same > folder. > >> Is This file located on your workstation or on the network? > > On the network > >>If it's on the network, what operating system are you using and what >>operating system is the network server using? > Running Windows 2000 on local... don't know what the network is running. > >>I ask because settings on the network server may be >> interfering, or your operating system may handle network requests a >> little >> differently than usual. >> >> > I have cold booted my system, resynced >> > folders >> >> What exactly are you doing to resync the directories? Copying files, >> their >> attributes, and their Windws security permissions so that both >> directories >> match precisely? > > The system was set up before I got here (contractor) and uses Win2k > syncronization. Not sure how it works but it supposedly syncronizes the > local > with the network??? > >>Does this task accidentally copy an errant .LDB file to the other >>matching directory? > > We have had multiple network outages and there may have been times when > the > network came back up and asked about saving files, etc. the wrong answer > was > given so perhaps the .ldb file that was on the server was not deleted even > though the application on the local was not running. This is where I think > the problem lies....somehow.... > > Guess the question is... how can I delete the .ldb file? > > Gunny?? as in Sarg? > >> >> HTH. >> Gunny >> >> See http://www.QBuilt.com for all your database needs. >> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. >> http://www.Access.QBuilt.com/html/expert_contributors2.html for contact >> info. >> >> >> "John" <John[ at ]discussions.microsoft.com> wrote in message >> news:587DACF4-4D98-455C-A3F1-CEA4D9ED886F[ at ]microsoft.com... >> >I have a persistent ldb file I need to get rid of. I am the only user, >> >the >> > LDBViewer shows it's ME logged in but I have cold booted my system, >> > resynced >> > folders, there's no one using the .mdb and yet the ldb file won't go >> > away. >> > How can I get rid of it? >> >> >>

Re: Delete LDB file John 07.06.2006 22:23:02 No disrespect intended, Gunny! When I said Sarge I meant Sergeant but didn't spell it out. I'm a retired Senior Chief and have the utmost respect for Gunny Sergeants! Thanks for being there, in more ways than one! "'69 Camaro" wrote: [Quoted Text] > Hi, John. > > >>If it's on the network, what operating system are you using and what > >>operating system is the network server using? > > Running Windows 2000 on local... don't know what the network is running. > > Ensure that opportunistic locks are disabled. Windows 2000 Server is the > most common culprit, but other operating systems have this feature, too. > For more information, please see the following Web page: > > http://support.microsoft.com/default.aspx?id=296264 > > > The system was set up before I got here (contractor) and uses Win2k > > syncronization. Not sure how it works but it supposedly syncronizes the > > local > > with the network??? > > I'm not familiar with this, so I can't comment on it. > > > We have had multiple network outages > > Access databases don't do well on a flaky network. It often leads to > corrupted database files. > > > network came back up and asked about saving files, etc. the wrong answer > > was > > given so perhaps the .ldb file that was on the server was not deleted even > > though the application on the local was not running. This is where I think > > the problem lies....somehow.... > > The Windows network administrator has tools that can show him which > workstation has a networked file locked. Perhaps its time to do some > sleuthing. If you can find out which workstation has the file locked, it > may lead to finding out how to prevent it from happening. > > > Guess the question is... how can I delete the .ldb file? > > If you can't delete it yourself though you have sufficient permissions to do > so (and it sounds like you do), have the Windows network administrator break > the lock on the file and delete the file for you. > > > Gunny?? as in Sarg? > > No. Gunny, as in "Gunnery Sergeant, United States Marine Corps." Army dogs > with three or more stripes are called Sarge. No Marine would suffer lightly > the indignity of being called Sarge, and no Marine who has earned at least > one rocker will answer to the name of Sergeant, because there's a huge > difference between the Staff NCO ranks and the NCO and non-NCO ranks. > > HTH. > Gunny > > See http://www.QBuilt.com for all your database needs. > See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. > http://www.Access.QBuilt.com/html/expert_contributors2.html for contact > info. > > > "John" <John[ at ]discussions.microsoft.com> wrote in message > news:10E1047F-F0A5-44F5-A08B-E769CDCC4D99[ at ]microsoft.com... > > In Line: > > > > "'69 Camaro" wrote: > > > >> Hi, John. > >> > >> >I have a persistent ldb file I need to get rid of. I am the only user > >> > >> Ensure that you have Windows security permissions to delete files in the > >> directory where the Access database file is located. > > > > I do have permissions verified by successfully deleting a file in the same > > folder. > > > >> Is This file located on your workstation or on the network? > > > > On the network > > > >>If it's on the network, what operating system are you using and what > >>operating system is the network server using? > > Running Windows 2000 on local... don't know what the network is running. > > > >>I ask because settings on the network server may be > >> interfering, or your operating system may handle network requests a > >> little > >> differently than usual. > >> > >> > I have cold booted my system, resynced > >> > folders > >> > >> What exactly are you doing to resync the directories? Copying files, > >> their > >> attributes, and their Windws security permissions so that both > >> directories > >> match precisely? > > > > The system was set up before I got here (contractor) and uses Win2k > > syncronization. Not sure how it works but it supposedly syncronizes the > > local > > with the network??? > > > >>Does this task accidentally copy an errant .LDB file to the other > >>matching directory? > > > > We have had multiple network outages and there may have been times when > > the > > network came back up and asked about saving files, etc. the wrong answer > > was > > given so perhaps the .ldb file that was on the server was not deleted even > > though the application on the local was not running. This is where I think > > the problem lies....somehow.... > > > > Guess the question is... how can I delete the .ldb file? > > > > Gunny?? as in Sarg? > > > >> > >> HTH. > >> Gunny > >> > >> See http://www.QBuilt.com for all your database needs. > >> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. > >> http://www.Access.QBuilt.com/html/expert_contributors2.html for contact > >> info. > >> > >> > >> "John" <John[ at ]discussions.microsoft.com> wrote in message > >> news:587DACF4-4D98-455C-A3F1-CEA4D9ED886F[ at ]microsoft.com... > >> >I have a persistent ldb file I need to get rid of. I am the only user, > >> >the > >> > LDBViewer shows it's ME logged in but I have cold booted my system, > >> > resynced > >> > folders, there's no one using the .mdb and yet the ldb file won't go > >> > away. > >> > How can I get rid of it? > >> > >> > >> > > >