Access "ldb"

Hot Topic

Removing Hyperlinks
Open an excel file
show vba application
VS Code Editor
Help with interface?
PPT command button link to other pres
Dialog Box, Searching for keywords in an Excel Workbook
Colored Named Ranges
Using internal IP Address (Printers) in VBA Code for Excel
Moving to Office 2003

Microsoft ISV

Data from serial port
Word Macro Runtime Error
VBA Compatibility and creating EXEs
vba error message
go to next line?
Modify .PRJ File
Named range in another open workbook
Accessing a subform control in MS Access
Live Communications Server tab does not show up
Sendin an Email through Excell, without attach the file

Access "ldb"

hello all

I use mdb as my app DB file, when my app first run, a ".ldb" file the name as same as my DB file appears.
Is there anyway can move the ".ldb"  to the windows temp document not in my app current document .thanks!

Answer this question

Access "ldb"

  • Brandon K

    per the support engineer...

    ".ldb" file is the locking information file in Access. Microsoft Access uses this information to control concurrency. By design, it is stored in the same folder as the .mdb file and we cannot change it. To change it, we may need to change source code of Access, which is a complex process and requires lots of business factors. Could you let me know why you want to store it in temporary folder Does it hurt performance So I can help check if we can have other methods.

    Here is some information regarding .ldb file:
    When you open an Access database file (.mdb) in shared mode, Microsoft Access also creates a locking information file (.ldb) with the same file name (for example, Northwind.ldb) and in the same folder as the database file. This locking information file stores the computer name (such as mypc) and security name (such as Admin) of each shared user of the database. Microsoft Access uses this information to control concurrency. In most cases, Microsoft Access automatically deletes the locking information file when the last user closes the database file.
     
    -brenda (ISV Buddy Team)


  • Access "ldb"
Answer this question