MS Access Query monitor

[DMogadati]

Hi,
Is it possible in MS Access to view at a given time how many users are
accessing the Access database and gain visibility into which query (s)
they are using...?

[Smartin]

DM*******@gmail.com wrote:

Hi,
Is it possible in MS Access to view at a given time how many users are
accessing the Access database and gain visibility into which query (s)
they are using...?

Yes, and no*, in that order.

For the "who in the database" question you can use a number of methods
for peeking into the locking file to see who has the database open.
Google "ldb viewer" for ideas. You can also capture and record logins
and logouts with code such as "fOSUserName" fired on open and close events.

*Since queries are executed on users' machines I suspect it would be
rather tricky to know who is using a particular query at a given moment,
but if you carefully control access to queries (e.g., by only allowing
access through a form) you could capture fOSUserName in events
associated with firing the queries.

--
Smartin

[pietlinden]

On Feb 19, 5:51 pm, Smartin <[e-mail]:

[e-mail] wrote:

Hi,
Is it possible in MS Access to view at a given time how many users are
accessing the Access database and gain visibility into which query (s)
they are using...?

Yes, and no*, in that order.

For the "who in the database" question you can use a number of methods
for peeking into the locking file to see who has the database open.
Google "ldb viewer" for ideas. You can also capture and record logins
and logouts with code such as "fOSUserName" fired on open and close events.

*Since queries are executed on users' machines I suspect it would be
rather tricky to know who is using a particular query at a given moment,
but if you carefully control access to queries (e.g., by only allowing
access through a form) you could capture fOSUserName in events
associated with firing the queries.

--
Smartin

You could do this by using an interface that effectively replaces the
normal Access UI. There's an example and the code in one of the
Access Developer's Handbooks. Not sure which version - probably
Desktop (not Enterprise).