Scheduled run of Access Query

[Pavel Madìra]

Can somebody help me with application which run Access query at night time
to update few tables automaticaly please.

I have c:\query \aplication.mnd which contain few query like "Atrikl",
"Emploee" and so on. I need to run periodically the "Artikl" Query by
Windows scheduller.

Tahnk for your help.

 

[MGFoster]

I have c:\query \aplication.mnd which contain few query like "Atrikl",
"Emploee" and so on. I need to run periodically the "Artikl" Query by
Windows scheduller.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

One way:

1) Open a Windows Explorer window to a folder that will hold a short-cut
file (to be created).
2) Open Access and display the Queries window.
3) Size the Windows Explorer window and the Access window so both can be
seen.
4) Right click on the query "Atrikl" and drag & drop it in the selected
folder in Windows Explorer.
5) Set up Windows scheduler to open the short cut file at the
appropriate time.

Caveat: The query will run at the assigned time, but the Access object
will remain open after the query has completed.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQnaIGIechKqOuFEgEQKyuACgxSgilJHQgbeavylpfX9DgN+OatEAn11E
hoz33gyHnexS9sZnpJhIplbp
=zl6a
-----END PGP SIGNATURE-----