M
marki
Hi
I need to create an Access application to track the users of a SQL
back end database. Unfortunately, the database has no auditing/
tracking, so it's up to me to find out some information about it's
use.
I'm planning on setting up a Timer Event to poll the SQL database at
regular intervals, and return some information about the logged-in
users.
Is it possible for Access to return the User who last changed the
value of a particular field in a particular SQL table?
I expect it can't be done, so as an alternative, is it possible to
return all the Users logged into a database at any given point, as
well as the Application they're using to get to the database? It'd
also be great if I could return the table(s) those users are currently
reading.
Failing all that, is there any third-party software that will do
this? Or something in SQL itself that will help out? I don't know
much about Enterprise Manager, or other built-in SQL tools, so any
help would be appreciated.
Thanks
Mark.
I need to create an Access application to track the users of a SQL
back end database. Unfortunately, the database has no auditing/
tracking, so it's up to me to find out some information about it's
use.
I'm planning on setting up a Timer Event to poll the SQL database at
regular intervals, and return some information about the logged-in
users.
Is it possible for Access to return the User who last changed the
value of a particular field in a particular SQL table?
I expect it can't be done, so as an alternative, is it possible to
return all the Users logged into a database at any given point, as
well as the Application they're using to get to the database? It'd
also be great if I could return the table(s) those users are currently
reading.
Failing all that, is there any third-party software that will do
this? Or something in SQL itself that will help out? I don't know
much about Enterprise Manager, or other built-in SQL tools, so any
help would be appreciated.
Thanks
Mark.