By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Help-How to delete a .mdb file?

P: n/a
Dear all,

I have an Access mdb file which I updated every other week on a server.
There are multiple users to access it. Usually when if somebody is
using it, I can see .ldb file under that folder. Right now I can't see
it and I am pretty sure that nobody is using it, but I can't delete it
and recreate a new one with the same file name. It still tells me that
it is using by another person or program. Is it corrupted? How can I
delete it? I am using windows XP and Microsoft Access 2003. Any
comments are greatly appreciated.

Helen

Aug 22 '06 #1
Share this Question
Share on Google+
15 Replies


P: n/a
Hi
I have an Access mdb file which I updated every other week on a
server. There are multiple users to access it. Usually when if
somebody is using it, I can see .ldb file under that folder. Right
now I can't see it and I am pretty sure that nobody is using it, but
I can't delete it and recreate a new one with the same file name. It
still tells me that it is using by another person or program. Is it
corrupted? How can I delete it? I am using windows XP and Microsoft
Access 2003. Any comments are greatly appreciated.
Try to unlock it with <Unlocker>, a small tool you can find here :

http://ccollomb.free.fr/unlocker/

Regards
Jens
Aug 22 '06 #2

P: n/a
Try renaming it. You should also look into WScript.Network and how to
get network usernames of people who have the database open.

Also, create a blank database with a single form which states "This
database is currently unavailable" and a button to exit the database.
Instead of giving everyone access to the database, hide it in a
subfolder and give them a shortcut instead. This way, when you need to
make changes you can change the shortcut to point to your temporary
database while you're updating the main database. Once you're
finished, change the shortcut back to the main database and everyone's
ready to go.

su********@hotmail.com wrote:
Dear all,

I have an Access mdb file which I updated every other week on a server.
There are multiple users to access it. Usually when if somebody is
using it, I can see .ldb file under that folder. Right now I can't see
it and I am pretty sure that nobody is using it, but I can't delete it
and recreate a new one with the same file name. It still tells me that
it is using by another person or program. Is it corrupted? How can I
delete it? I am using windows XP and Microsoft Access 2003. Any
comments are greatly appreciated.

Helen
Aug 22 '06 #3

P: n/a
Thanks,Jens. But it doesn't work. I tried using Unlocker to delete or
rename and got message that it can't be done and even I chose delete
after reboot, the file still there. Any other suggestions?

Jens Schilling wrote:
Hi
I have an Access mdb file which I updated every other week on a
server. There are multiple users to access it. Usually when if
somebody is using it, I can see .ldb file under that folder. Right
now I can't see it and I am pretty sure that nobody is using it, but
I can't delete it and recreate a new one with the same file name. It
still tells me that it is using by another person or program. Is it
corrupted? How can I delete it? I am using windows XP and Microsoft
Access 2003. Any comments are greatly appreciated.

Try to unlock it with <Unlocker>, a small tool you can find here :

http://ccollomb.free.fr/unlocker/

Regards
Jens
Aug 22 '06 #4

P: n/a
Thanks for the reply, ManningFan.

But how to use WScript.Network to find out who is using the database?
Fogive me about this, I am totally newbie of WScript stuff.
ManningFan wrote:
Try renaming it. You should also look into WScript.Network and how to
get network usernames of people who have the database open.

Also, create a blank database with a single form which states "This
database is currently unavailable" and a button to exit the database.
Instead of giving everyone access to the database, hide it in a
subfolder and give them a shortcut instead. This way, when you need to
make changes you can change the shortcut to point to your temporary
database while you're updating the main database. Once you're
finished, change the shortcut back to the main database and everyone's
ready to go.

su********@hotmail.com wrote:
Dear all,

I have an Access mdb file which I updated every other week on a server.
There are multiple users to access it. Usually when if somebody is
using it, I can see .ldb file under that folder. Right now I can't see
it and I am pretty sure that nobody is using it, but I can't delete it
and recreate a new one with the same file name. It still tells me that
it is using by another person or program. Is it corrupted? How can I
delete it? I am using windows XP and Microsoft Access 2003. Any
comments are greatly appreciated.

Helen
Aug 22 '06 #5

P: n/a
Do a search on Google for "WScript.Network". You should be able to
find code written to call the usernames off a network. It's pretty
handy, especially when you have to go figure out who is still in a
database alot.

su********@hotmail.com wrote:
Thanks for the reply, ManningFan.

But how to use WScript.Network to find out who is using the database?
Fogive me about this, I am totally newbie of WScript stuff.
Aug 22 '06 #6

P: n/a
Hi
Thanks,Jens. But it doesn't work. I tried using Unlocker to delete or
rename and got message that it can't be done and even I chose delete
after reboot, the file still there. Any other suggestions?
No - Sorry...

I remember that I have once struggled with similar problems - as described
here http://support.microsoft.com/kb/814112/en-us - but that was on
machines only with WinXP SP1. Service Pack 2 fixed these problems.

Regards
Jens



Aug 22 '06 #7

P: n/a
su********@hotmail.com wrote in
news:11**********************@m73g2000cwd.googlegr oups.com:
I have an Access mdb file which I updated every other week on a
server. There are multiple users to access it. Usually when if
somebody is using it, I can see .ldb file under that folder. Right
now I can't see it and I am pretty sure that nobody is using it,
but I can't delete it and recreate a new one with the same file
name. It still tells me that it is using by another person or
program. Is it corrupted? How can I delete it? I am using windows
XP and Microsoft Access 2003. Any comments are greatly
appreciated.
Anyone with administrative permission on the server can use the
Windows management console to view open files to see who is holding
the lock on the file. Sometimes a workstation has to be rebooted or
a user has to log off before the file locks are fully released, even
though the user no longer has the file open.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Aug 23 '06 #8

P: n/a
Bri

David W. Fenton wrote:
Anyone with administrative permission on the server can use the
Windows management console to view open files to see who is holding
the lock on the file. Sometimes a workstation has to be rebooted or
a user has to log off before the file locks are fully released, even
though the user no longer has the file open.
Sorry to jump in on this thread, but which snap-in would I use to do
this? I can't seem to find anything that shows open files or file locks.

--
Bri

Aug 23 '06 #9

P: n/a
Bri <no*@here.comwrote in news:sm1Hg.446259$Mn5.390411@pd7tw3no:
David W. Fenton wrote:
>Anyone with administrative permission on the server can use the
Windows management console to view open files to see who is
holding the lock on the file. Sometimes a workstation has to be
rebooted or a user has to log off before the file locks are fully
released, even though the user no longer has the file open.

Sorry to jump in on this thread, but which snap-in would I use to
do this? I can't seem to find anything that shows open files or
file locks.
In the computer management console (compmgmt.msc), it's under SHARED
FOLDERS. You can run it locally and log onto the server remotely,
assuming you have admin permissions on both machines.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Aug 24 '06 #10

P: n/a
Thanks David. The person who maintains our server is on vacation now.
And the backup guy seems doesn't know how to do it. I have to wait
until next week. I'll keep you posted. Thanks again!

Helen

David W. Fenton wrote:
Bri <no*@here.comwrote in news:sm1Hg.446259$Mn5.390411@pd7tw3no:
David W. Fenton wrote:
Anyone with administrative permission on the server can use the
Windows management console to view open files to see who is
holding the lock on the file. Sometimes a workstation has to be
rebooted or a user has to log off before the file locks are fully
released, even though the user no longer has the file open.
Sorry to jump in on this thread, but which snap-in would I use to
do this? I can't seem to find anything that shows open files or
file locks.

In the computer management console (compmgmt.msc), it's under SHARED
FOLDERS. You can run it locally and log onto the server remotely,
assuming you have admin permissions on both machines.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Aug 24 '06 #11

P: n/a
Bri
David W. Fenton wrote:
Bri <no*@here.comwrote in news:sm1Hg.446259$Mn5.390411@pd7tw3no:
>>Sorry to jump in on this thread, but which snap-in would I use to
do this? I can't seem to find anything that shows open files or
file locks.

In the computer management console (compmgmt.msc), it's under SHARED
FOLDERS. You can run it locally and log onto the server remotely,
assuming you have admin permissions on both machines.
OK, found 'Shared Folders - Open Files' but the list is empty. I suspect
this will only show files opened via a share, not files opened by apps
on the current PC. Anything in there that will do that? Thanks.

--
Bri

Aug 24 '06 #12

P: n/a
Bri <no*@here.comwrote in news:dykHg.451950$iF6.273717@pd7tw2no:
David W. Fenton wrote:
>Bri <no*@here.comwrote in
news:sm1Hg.446259$Mn5.390411@pd7tw3no:
>>>Sorry to jump in on this thread, but which snap-in would I use to
do this? I can't seem to find anything that shows open files or
file locks.

In the computer management console (compmgmt.msc), it's under
SHARED FOLDERS. You can run it locally and log onto the server
remotely, assuming you have admin permissions on both machines.

OK, found 'Shared Folders - Open Files' but the list is empty. I
suspect this will only show files opened via a share, not files
opened by apps on the current PC. Anything in there that will do
that? Thanks.
Oh. I thought it was a file on a server.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Aug 24 '06 #13

P: n/a
Bri


David W. Fenton wrote:
Bri <no*@here.comwrote in news:dykHg.451950$iF6.273717@pd7tw2no:

> David W. Fenton wrote:
>>>Bri <no*@here.comwrote in
news:sm1Hg.446259$Mn5.390411@pd7tw3no:

Sorry to jump in on this thread, but which snap-in would I use to
do this? I can't seem to find anything that shows open files or
file locks.

In the computer management console (compmgmt.msc), it's under
SHARED FOLDERS. You can run it locally and log onto the server
remotely, assuming you have admin permissions on both machines.

OK, found 'Shared Folders - Open Files' but the list is empty. I
suspect this will only show files opened via a share, not files
opened by apps on the current PC. Anything in there that will do
that? Thanks.


Oh. I thought it was a file on a server.
It may have been for the OP, but I jumped in thinking that it would work
for locally opened files.

--
Bri

Aug 25 '06 #14

P: n/a
Bri <no*@here.comwrote in news:agFHg.468363$IK3.20919@pd7tw1no:
David W. Fenton wrote:
>Bri <no*@here.comwrote in
news:dykHg.451950$iF6.273717@pd7tw2no:
>> David W. Fenton wrote:

Bri <no*@here.comwrote in
news:sm1Hg.446259$Mn5.390411@pd7tw3no:

>Sorry to jump in on this thread, but which snap-in would I use
>to do this? I can't seem to find anything that shows open files
>or file locks.

In the computer management console (compmgmt.msc), it's under
SHARED FOLDERS. You can run it locally and log onto the server
remotely, assuming you have admin permissions on both machines.

OK, found 'Shared Folders - Open Files' but the list is empty. I
suspect this will only show files opened via a share, not files
opened by apps on the current PC. Anything in there that will do
that? Thanks.

Oh. I thought it was a file on a server.

It may have been for the OP, but I jumped in thinking that it
would work for locally opened files.
If you opened it through the local PC's C$ hidden administrative
share, that would work. ;)

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Aug 29 '06 #15

P: n/a

Finally Our DBA found that one workstation locked the database on
operation level (I don't know what that exactly means, that's what I
was told). He removed the lock, then I was able to delete it.

Thanks you all for the help. I really appreciate it.

Helen

Aug 30 '06 #16

This discussion thread is closed

Replies have been disabled for this discussion.