Q: Query Run history?

M

MarkD

hey,

Using Access 2000. Is there a run history of queries? I'd
like to know if a query was run in a database yesterday.

Figure probably not, but whadda I know...

Thanks!
-Mark
 
T

Tom Wickerath

No built in functionality of this type. However, if you restrict your users to interacting with
forms and reports only, so that they do not have access to the database window, then you can
create a form with command buttons to run the queries. As a part of the click event procedure for
each command button, you can call a function that you write that records the user information,
name of the query, and date/time to a table.

Tom
___________________________________


hey,

Using Access 2000. Is there a run history of queries? I'd
like to know if a query was run in a database yesterday.

Figure probably not, but whadda I know...

Thanks!
-Mark
 
M

MarkD

Thanks for the reply, Tom.

Actually (and kinda embarassing to admit), I asked this
question because I *didn't* run a query (I think) and
wanted to verify that was the case. I suppose your
solution would still be an option, but as the db
programmer, I usually run the queries themselves as they
need modifications.

I figured one of the MSys tables would have that info, but
if not, oh well...

-Mark

-----Original Message-----
No built in functionality of this type. However, if you
restrict your users to interacting with
forms and reports only, so that they do not have access
to the database window, then you can
create a form with command buttons to run the queries. As
a part of the click event procedure for
each command button, you can call a function that you
write that records the user information,
 
Top