i have made a query in access which takes data from
one table and puts it into another table. I want to
schedule it to work automatically once in a week.
What should be done?

Several methods can be used to schedule this processing. The most reliable is the following:

1. Configure an ODBC profile for your Access database (Administrative Tools in the Windows Control Panel).
2. In 24x7 configure a Database profile pointing to the ODBC profile setup in step 1 (Tools/Database Profiles menu; select ODBC; click New button).
3. Create a "database" type job and copy & paste the entire query text (File/New/Job menu).
4. Schedule this job to run as often as needed.

: i have made a query in access which takes data from
: one table and puts it into another table. I want to
: schedule it to work automatically once in a week.
: What should be done?