Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    1

    Question Unanswered: Access 2002 - Compact/Repair and BackUp

    I am a novice at this game but I have developed a database with Access 2002 which I hope to distribute with Access Runtime. I have one major problem I need help with. I would like the system to automatically do a Compact / Repair and BackUp of the "back end" when the user selects to exit the database.
    Any help on this subject would be greatly appreciated.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by kevinfalq
    I am a novice at this game but I have developed a database with Access 2002 which I hope to distribute with Access Runtime. I have one major problem I need help with. I would like the system to automatically do a Compact / Repair and BackUp of the "back end" when the user selects to exit the database.
    Any help on this subject would be greatly appreciated.
    Hi Kevin

    Welcome to the forum.

    A few discussions:
    http://www.dbforums.com/t1197289.html
    http://www.dbforums.com/t1051622.html
    http://www.dbforums.com/t998048.html

    The main one I was looking for looks like it was lost in the Great Data Loss of '05.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    compact it
    ========
    one of the easy way to compact/repair the database

    set the database to compact on close tools->options

    Know in the backend data base create a macro call autoexec

    and get it to quick

    now build a scheduled task to open the backend database

    autoexec get run it quicks then it compacts done


    also it keep out people out of the database if they try to open it.

    backup
    =====
    have the database in a place where it is part of the company daliy backups
    Last edited by myle; 01-13-06 at 15:59.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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