Unanswered: Tell access to run a query or macro every 30 seconds
ok, here is an easy one.
How and where do I tell my Access database to run a macro or query every 30 seconds. And do I risk creating a memory hole by leaving this access database open and running for months at a time?
I could set the fields to not accept records coinating certain values, but then HTTPLOG system errors begin to appear in the Event log. Its looking like my only option is to have something running continously to purge the log table of unwanted data.