Q: Query Run history?

[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

 

[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

 

[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,