Delete LDB file

[Guest]

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?

 

['69 Camaro]

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. 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.

 

[Guest]

In Line:

Hi, John.


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.


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?

 

[Andy]

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

 

['69 Camaro]

Hi, John.

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.

 

[david epsom dot com dot au]

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)

 

[Guest]

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!