Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Differential Backup

Discussion in 'Information Technology' started by Prabhat, Jul 28, 2006.

  1. Prabhat

    Prabhat
    Expand Collapse
    Guest

    Hi Friends,

    Is it possible that we can have Differential Backup in MS Access ver. 2000
    or above? If yes how?

    Or Can we write a program in VB / Delphi that will do that work for me?

    Thanks
    Prabhat
     
  2. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 19 Jun 2006 17:01:36 +0530, "Prabhat" <not_a_mail@hotmail.com>
    wrote:

    >Hi Friends,
    >
    >Is it possible that we can have Differential Backup in MS Access ver. 2000
    >or above? If yes how?
    >
    >Or Can we write a program in VB / Delphi that will do that work for me?
    >
    >Thanks
    >Prabhat
    >


    What do you want to back up? Access Table data? The Access application
    itself? Your hard disk (using Access to track what's backed up where)?

    Details please!

    John W. Vinson[MVP]
     
  3. Prabhat

    Prabhat
    Expand Collapse
    Guest

    Hi,

    Mainly I need to track the table data updates. Also onece in a week entire
    Access DB.

    Please let me know any other details you need.

    Prabhat


    > What do you want to back up? Access Table data? The Access application
    > itself? Your hard disk (using Access to track what's backed up where)?
    >
    > Details please!
    >
    > John W. Vinson[MVP]
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 20 Jun 2006 13:27:58 +0530, "Prabhat" <not_a_mail@hotmail.com>
    wrote:

    >Hi,
    >
    >Mainly I need to track the table data updates. Also onece in a week entire
    >Access DB.


    Could you explain what you mean by "track the table data updates"? Are
    you looking for an audit trail, indicating who updated which record
    and when? Or a true field-for-field backup?

    There are some good audit trail samples out on the web; one you might
    want to look at is http://allenbrowne.com/AppAudit.html.


    John W. Vinson[MVP]
     
  5. Prabhat

    Prabhat
    Expand Collapse
    Guest

    Hi John,
    Thanks for reply. Actually I wanted to know how many ways are there to
    Backup a MS Access DB? As far I know the backup mean we have to keep a DB
    copy in a regular interval of time: say Once daily at mid night. So here we
    are backing up the entire DB as a whole file, So can we make a differential
    backup like MS SQl Server or Oracle?

    Thanks
    Prabhat

    > Could you explain what you mean by "track the table data updates"? Are
    > you looking for an audit trail, indicating who updated which record
    > and when? Or a true field-for-field backup?
    >
    > There are some good audit trail samples out on the web; one you might
    > want to look at is http://allenbrowne.com/AppAudit.html.
    >
    >
    > John W. Vinson[MVP]
     
  6. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 20 Jun 2006 22:14:40 +0530, "Prabhat" <not_a_mail@hotmail.com>
    wrote:

    >Hi John,
    >Thanks for reply. Actually I wanted to know how many ways are there to
    >Backup a MS Access DB? As far I know the backup mean we have to keep a DB
    >copy in a regular interval of time: say Once daily at mid night. So here we
    >are backing up the entire DB as a whole file, So can we make a differential
    >backup like MS SQl Server or Oracle?


    There are no built-in tools to do so. You can, of course, create your
    own by linking to a separate backend .mdb file and running Append
    queries - but this would be complex and hard to manage!

    Have you considered using MSDE or SQL/Server Express - or for that
    matter SQL/Server, if you have it available - as the table repository,
    instead of using .mdb files? This can give you the best of both: the
    hot backups, transactions, etc. of SQL with the ease of development of
    an Access frontend.

    John W. Vinson[MVP]
     

Share This Page