Schedule Running A Query 
Author Message
 Schedule Running A Query

Hi there,

Is it possible to schedule a query in access 2000? I want to run a
query when server is low in use.

Thnx in advance

Nico



Tue, 26 Jul 2005 16:41:14 GMT  
 Schedule Running A Query

Quote:

> Hi there,

> Is it possible to schedule a query in access 2000? I want to run a
> query when server is low in use.

You need some type of scheduler program or cron utility. NT and W2K
have the Scheduler service that allows you to use the AT command to
schedule the running of a program at a preset time.

Do you really want to run a query? Do you mean you want to print out
the results of a query or are you updating records with an update/
insert query?

The scheduler runs with System permissions which are extremely limted
however, you can have the Scheduler service run as any account you
want but there are security issues to consider (which would be true
of any scheduler/cron type facility).

What is the final product you hope to achieve? To display a query on
the monitor of the PC that runs this scheduled program?

--
'-------------------------------
' John Mishefske
'-------------------------------



Tue, 26 Jul 2005 16:46:22 GMT  
 Schedule Running A Query
Hi there,

Thanks for the reply

I want to match an internal database with 800k zipcodes with another
database with 8m zipcodes. The result will be a new table. This query
will run once a month and will be available for all users on the
network.

Access 2000 is running on a NT machine.

Nico

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Tue, 26 Jul 2005 19:51:00 GMT  
 Schedule Running A Query

Quote:

> Hi there,

> Thanks for the reply

> I want to match an internal database with 800k zipcodes with another
> database with 8m zipcodes. The result will be a new table. This query
> will run once a month and will be available for all users on the
> network.

> Access 2000 is running on a NT machine.

> Nico

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

One possible solution...

If the Scheduler service is running on your NT box then you can use the
AT command to schedule a job to run on a recurring basis.

Use it to start an Access database that contains an AutoExec macro that
calls a function. The function runs your query/process and exits when done.

Scheduler runs jobs as "System" - a user with minimal permissions. It
will not have network permissions; if that is needed for this task you
have to consider running the Scheduler service as a different user that
does have network access. You should investigate the security impacts
of doing this prior to implementing.

--
'-------------------------------
' John Mishefske
'-------------------------------



Tue, 26 Jul 2005 23:24:46 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Can you schedule a query to run in Access 97

2. How Can I Schedule A Query to automatically run every day at 2:00am

3. Schedule Report Runs from Queries

4. Running a Query on a scheduled Date

5. scheduling query to run non-interactively

6. Automating/Scheduling/Executing Queries (without Access already running)

7. Scheduling A Query To Run

8. Automating/Scheduling/Executing Queries (without Access already running)

9. Automating/Scheduling/Executing Queries (without Access already running)

10. Code to schedule modules to run every hour (or multiple daily runs)


 
Powered by phpBB® Forum Software © phpBB Group