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.
...much more complex...
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.