Could MS give us a tool to trash disconnected ldb files?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Perhaps Microsoft will see this?

It would really be a great service to MS-Access users if Microsoft could
develop a tool, perhaps something like a bat file or exe that allows you to
point to a disconnected ldb and trash it.

I just spent a whole day trying to resolve this sort of issue and I know
others have too. Just a suggestion - or perhaps something already exists? If
so, I would like to know about it; also, no one posted anything about it when
I was asking the question...
 
What happens if you try to delete the ldb file? If you can't, then the mdb
file is still in use.
 
Hi.
It would really be a great service to MS-Access users if Microsoft could
develop a tool, perhaps something like a bat file or exe that allows you
to
point to a disconnected ldb and trash it.
Click to expand...

Microsoft has two tools available. The first one is the LDB Viewer, which
allows one to see which users are currently connected to the MDB file. If
those users have already disconnected (reboot their workstations to ensure
this), and the LDB file cannot be deleted by a user who has delete
permissions on files in this directory, then there's a network lock on the
file. Contact a Windows network administrator to use his network tool to
unlock the LDB file, because you as a regular user you don't have the domain
permissions to unlock it yourself, even if you had a script or batch file
available to unlock and delete the file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Microsoft has two tools available. The first one is the LDB
Viewer, which allows one to see which users are currently
connected to the MDB file. If those users have already
disconnected (reboot their workstations to ensure this), and the
LDB file cannot be deleted by a user who has delete permissions on
files in this directory, then there's a network lock on the file.
Contact a Windows network administrator to use his network tool to
unlock the LDB file, because you as a regular user you don't have
the domain permissions to unlock it yourself, even if you had a
script or batch file available to unlock and delete the file.
Click to expand...

MS never updated the msldbusr.dll for Jet 4, because they provide
the UserRoster function in ADO. However, the Jet 3.5 msldbusr.dll
still works for basic functions with Jet 4 data. I just posted a
revived Admin utility that includes both UserRoster-based user
lookup and DLL-based lookup. You can download it here:

http://dfenton.com/DFA/download/Access/Admin.zip

It's a work in progress, based on old code written in 1998 that I've
just updated for one of my clients to use, but it basically works.
I'm sure it can be improved, though.
 
Back
Top