Link to home
Start Free TrialLog in
Avatar of hpfam
hpfam

asked on

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.
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

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...
Avatar of hpfam
hpfam

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial