Thanks Laurent. That was very helpful. Pretty easy too. Thanks again for your help. Tony
"Laurent Pointal" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Tony a écrit : >> I'm new at this and would like to know how set up a script to copy a >> database from a local computer to a network at a certain time everyday. >> Should be simple enough, but, as of now I am unfamiliar with how to do >> this. Would this be done by writing a script and setting up a scheduled >> task to run the script? Can anyone help me with the script? Just need >> it to copy an Access database from the local C: drive to a network F: >> drive. >> >> Thanks, >> Tony > > As you wrote about c: and f:, I imagine you are working under Windows. > IMHO you dont need Python for that. > > domybackup.bat > > copy c:\mypathtothefile\thefile.xxx F:\mypathdobackudir\ > > > And use your "planificateur de taches" (its corresponding english control > panel) to setup a periodic call to this batch file, eventually associate > an ad-hoc account to the task, so that the batch can access the file to > backup. > > > If you need more (ie. network access to setup/clean), here is a copy of a > script I use to export (using a Python script) an Access database. Just > replace the call to the Python script by a simple call to copy xxx yyyy. > > > > @echo off > REM LANCEMENT DE L'EXPORT DE LA BASE ADMINISTRATIVE EN MODE TACHE > REM DE FOND (BATCH). > > SET EXPORTS_BATCH=1 > REM Parametres pour se connecter a la machine de transfert. > SET EXPORTS_HOST=thecomputer > SET EXPORTS_SHARE=data > SET EXPORTS_DRIVE=O: > SET EXPORTS_USER=theremotuser > SET EXPORTS_PASSWD=theremotepasswd > REM Montage du volume. > REM le start pour permettre d'attendre que le montage soit effectif. > START /wait NET USE %EXPORTS_DRIVE% \\%EXPORTS_HOST%\%EXPORTS_SHARE% > %EXPORTS_PASSWD% /USER:%EXPORTS_USER% /PERSISTENT:No > IF ERRORLEVEL 1 GOTO erreur_montage > > REM Parametres pour le script Python. > SET SCRIPT_EXPORT="C:\Documents and Settings\myaccount\My > Documents\mybexport.py" > SET DSN_BASE_ADMIN=mydbaccound > SET LOGIN_BASE_ADMIN=mydbpasswd > SET PATH_FICHIERS_EXPORTS=%EXPORTS_DRIVE%\ > REM Variables d'environnement eventuellement utiles... > SET TEMP=%PATH_FICHIERS_EXPORTS% > SET TMP=%PATH_FICHIERS_EXPORTS% > REM Lancement du script Python qui realise l'export. > C:\Tools\Python24\python.exe %SCRIPT_EXPORT% > > REM Deconnexion du volume. > NET USE %EXPORTS_DRIVE% /DELETE > > goto termine > > :erreur_montage > ECHO "Erreur %ERROR_LEVEL% au montage de \\%EXPORTS_HOST%\%EXPORTS_SHARE% > en lecteur %EXPORTS_DRIVE%." > > :termine
-- http://mail.python.org/mailman/listinfo/python-list