.ldb - Access.LockFile.9

.ldb - Access.LockFile.9


What exactly does the above the above extension mean?  When I open my db this file opens and when I close it, it disappears.  I know it's some sort of file showing the application is open, but I don't know the "in depth" meaning of it.  Could someone explain?

I'm having a problem running some code in my app.  Everything was working fine when I left, now all the sudden I'm getting the "Program Error" from windows and of course, my app closes.  I've noticed after I close out of my program the .ldb file stays..  It should close, right?  

But my backup seems to work fine, ?!?!?!?!?!?!?!!?...

scorp8

LVL 1
scorp8Asked:
Who is Participating?
 
CharitygConnect With a Mentor Commented:
Microsoft has a Jet Utility that includes LDB View. It has a user interface that allows you to select a database and view the users currently logged into the database as well as anyone who left the database in a suspect manner. (Corrupt)
http://support.microsoft.com/support/kb/articles/Q176/6/70.ASP

This is the Microsoft download site.

Also include with the utility is a white paper on Understanding Microsoft Jet Locking

Hope this helps
0
 
nancy_bumblesCommented:
the ldb is a locking file.  Alows other instances of the database (i.e. in a multi user environment) to see what lines etc are locked and ensure that no one elses edits the same line you are!

at least thats what i believe it does...

may well do more than that as well but its a start for you!"

i am sure someone else will give you a more complex explanation !
0
 
scorp8Author Commented:
I was guessing that's one of the things it does, but wasn't sure..  Seems logical...
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
nancy_bumblesCommented:
the ldb is a locking file.  Alows other instances of the database (i.e. in a multi user environment) to see what lines etc are locked and ensure that no one elses edits the same line you are!

at least thats what i believe it does...

may well do more than that as well but its a start for you!"

i am sure someone else will give you a more complex explanation !
0
 
nancy_bumblesCommented:
oops didn't mea nto send it twice sowwy!! not that interesting is it!!
but you notice if you open it twice there is only one file created...so you can see its like a global locking database....that all the people use!!!
0
 
shagemanCommented:
The .ldb file is used to determine which records are locked in a shared database and by whom.  For every database opened, an .ldb file is created to store computer and security names.  Whenever the last user closes a database, the .ldb file is deleted.
The only exceptions are when a user does not have delete rights or when the database is marked as corrupted; then, the .ldb file is not deleted because it contains information about who was using the database at the time the database was marked as corrupted.

Summary of MSDN Article Q208778
0
 
scorp8Author Commented:
shageman, how would I open the .ldb file to check and see who was in it?
0
 
shagemanCommented:
To the best of my understanding, it is written binary, so I don't know an easy way to open it in a view mode.  You may want to take a look at this, this will give you some direction.
http://support.microsoft.com/support/kb/articles/Q198/7/55.ASP

http://support.microsoft.com/support/kb/articles/Q208/7/78.ASP
0
 
shagemanCommented:
scorp,

You should be able to view it with notepad if the file is not in use
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
You can view the .LDB file with notepad.  Also, you can use the roster functionality in JET 4.0.  If JET 3.x, then you can use some built-in functions MSLDBUSR.DLL (think I got the name right).  For prior versions, you can open and parse the file directly.

And just to clairify a point, the locks are never physically written to that file, but taken against that with with the OS/NOS.  The LDB file will never grow larger then 16K.

Jim.
0
 
scorp8Author Commented:
thank you....
0
 
pacificsfCommented:
I am having the same problem, but only after I installed Windows XP Professional Service Pack 2.  It prevents other users in the shared network folder from opening the file.
0
All Courses

From novice to tech pro — start learning today.