Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    Danbury,ct 06801
    Posts
    24

    Unhappy Unanswered: Export backend tables every night (BD access 97)

    i want to make copy of backend tables my database every night or import the backend tables ... n put in to other directory....

    i iam not sure how i am going to do this ...

    pl help

    thanx


    hiten

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    Make a copy of the Access Base ( MyBase.mdb) to another Folder
    Saludos
    Norberto

  3. #3
    Join Date
    Nov 2003
    Posts
    1,487
    Hmmmm.....

    Code:
    FileCopy mySourcePath & "\MyBackend.mdb", MyDestinationPath & "\myBackend.mdb"

  4. #4
    Join Date
    Nov 2003
    Location
    Danbury,ct 06801
    Posts
    24
    1 more question after that is

    how would i trigger that ... at night ...with server...

    hiten
    hbhavsar

  5. #5
    Join Date
    Nov 2003
    Location
    Surrey, UK
    Posts
    2
    Assuming that your server is running Windows NT, use the AT command. Open a DOS window, and enter something like:

    at 01:00 /every:M,T,W,Th,F "copy \mySourcePath\myFile.mdb \myDestinationPath\myBackup.mdb"

    If you then just type:

    at

    it will show what timed jobs you have set up on the server.

    regards
    Craig

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •