Backing and restoring of Data

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sammentor
    New Member
    • Jan 2007
    • 7

    Backing and restoring of Data

    I don't know how to go about with writing codes of backing up and restoring data.
    pls help!
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #2
    Originally posted by sammentor
    I don't know how to go about with writing codes of backing up and restoring data.
    You'd probably be better off getting a commercial (or perhaps freeware) backup product.

    What sort of data, anyway? And what VB version do you use?

    Comment

    • sammentor
      New Member
      • Jan 2007
      • 7

      #3
      Originally posted by Killer42
      You'd probably be better off getting a commercial (or perhaps freeware) backup product.

      What sort of data, anyway? And what VB version do you use?
      am sorry for that inadequate info.
      i want to backup my MS Access tables using vb6.0
      I hope is clear now

      Comment

      • Killer42
        Recognized Expert Expert
        • Oct 2006
        • 8429

        #4
        Originally posted by sammentor
        am sorry for that inadequate info.
        i want to backup my MS Access tables using vb6.0
        I hope is clear now
        I suppose you still need to decide what sort of backup regime is right for your data - I wouldn't know about that.

        But on the technical side, it would be pretty simple to put together an Append or Make Table query to copy each table to a backup database. Or you could copy the MDB file, or probably numerous other options.

        Restoring may be very simple or very complex, depending on what sort of restore capabilities you want. At the simplest end, you could just copy back the MDB file, overwriting the old "real" one. Then there are varying levels of complexity once you start looking at replacing tables, or individual records, and making decisions on which ones to replace, etc etc.

        I think you need to define your requirements much better before you get into too much detail on how to achieve them. Basically, if you can define precisely enough what you want to do, the chances are very good that you can find a way to do it. And we can almost certainly help.

        Comment

        • sammentor
          New Member
          • Jan 2007
          • 7

          #5
          Thank you so much for that idea, that is a very useful tip

          Comment

          • Lavs
            New Member
            • Mar 2007
            • 16

            #6
            Halu! i have a problem of how to create a backup files. My file is a database file created in MS Access. I want to copy the whole mdb file to another directory. Is there a command in vb6.0 for copying files from one directory to another? I badly need it now...

            Comment

            Working...