• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 391
  • 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.
0
hpfam
Asked:
hpfam
  • 2
1 Solution
 
peter57rCommented:
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.

0
 
peter57rCommented:
...much more complex...
0
 
hpfamAuthor Commented:
peter57r:

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

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccessdev/html/ODC_MicrosoftJetlockingtechniques.asp

  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.

JimD.
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

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