• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 392
  • Last Modified:

LDB possiblity

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.
  • 2
1 Solution
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.

...much more complex...
hpfamAuthor Commented:

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.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<< 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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now