LDB possiblity

Posted on 2007-10-12
Last Modified: 2012-05-05
With this large database of attached tables I need to find out all who in a specific table.  I would like to do this programmicatlly without using the ldb viewer. Code would be extremely helpful.   Seeing the number of transactions that is happening would also be helpful.  Any help on this would be greatly appreicated.
Question by:hpfam
    LVL 77

    Expert Comment

    The question is potentially much more comples than you state.

    What about queries involving the table; reports based on the table; forms based on the table; combo boxes/listboxes using a the table in a rowsource; Controls using Dlookups() or similar against the table; recordsets based on the table or based on a query involving the tabel... and so on...

    You need to be specific about what you want to achieve and obviously the more monitoring you want the more code you will need.

    LVL 77

    Expert Comment

    ...much more complex...

    Author Comment


    I would like to know which queries are currently in the table. I also would like to know which user who is currently running it.  The intent for this is diagnostic purposes.  Periodically we will have a table which is not locked up but is responding extremely slow.  Any help in this would be appreciated.
    LVL 56

    Accepted Solution

    << I would like to do this programmicatlly without using the ldb viewer.>>

      If you are using MDB's (a JET database) to store data, then the only way to do that is to poll the OS/NOS for what locks it's holding on the file, then determine what table(s) occupy that address range.  To date, no one that I know of has bothered to come up with such a utility.  

      But if you want to try, the place to start is the "Understanding Microsoft JET Locking" white paper by Kevin Collins.  It can be found here:

      Scroll to the bottom and read where it talks about the LDB Viewer and the DB Lock Utility.

      Note that nothing has been published (at least that I'm aware of) on JET 4.0's locking scheme, so you may get no where fast.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Suggested Solutions

    Title # Comments Views Activity
    Running Sum Issue 7 21
    VBA exception error 5 22
    Calulated Field in MSAccess 11 15
    Mysql not caching queries 4 32
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now