Results 1 to 10 of 10

Thread: [RESOLVED] MDB file

  1. May 9th, 2013, 08:32 AM #1
    Bonzo2008
    Bonzo2008 is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 2011
    Location
    Greece
    Posts
    164

    Resolved [RESOLVED] MDB file

    Hi

    I have a program that use mdb file to store data.

    What I will do with this is to backup the file

    I know how to do that, but the question is
    how to make backup of the file so I can
    go back and restore the file from 10 Days ago.

    I mean how to number the file we say

    like this phone.mdb
    phone.mdb1
    and so on

    Lenny
    Reply With Quote Reply With Quote
  2. May 9th, 2013, 10:52 AM #2
    RhinoBull
    RhinoBull is offline
    PowerPoster RhinoBull's Avatar
    Join Date
    Mar 2004
    Location
    New Amsterdam
    Posts
    24,132

    Re: MDB file

    You can add date/time stamp to file name. Try something like this:
    Code:
    FileCopy "c:\source_folder\mydata.mdb", "c:\backup_folder\mydata" & Format(Now, "mmddyyy_hhnnss") & ".mdb"
    Microsoft MVP - Visual Basic 2006-2013

    Why VB clears the clipboard on startup and how to avoid it? . Filtering Arrays . Save File To Database . Extract File From Database .
    Extract picture from database without using hard drive . Change Menu BackColor . How to use MS Flexgrid . Make Frame Transparent .
    The Easiest Way to Create an NT Service With VB6 . How to comment blocks of code in VB5 and VB6 . How to find and replace missing members of control array
    Visual Basic 6.0 On-Line Documentation . Connection Strings
    Reply With Quote Reply With Quote
  3. May 9th, 2013, 12:28 PM #3
    Bonzo2008
    Bonzo2008 is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 2011
    Location
    Greece
    Posts
    164

    Re: MDB file

    Thanks it works just fine

    How can I get the file back from the backup dir?????
    Reply With Quote Reply With Quote
  4. May 9th, 2013, 01:37 PM #4
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: MDB file

    Same way... only in reverse... just copy the backup over the original.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  6. May 9th, 2013, 01:53 PM #5
    Bonzo2008
    Bonzo2008 is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 2011
    Location
    Greece
    Posts
    164

    Re: MDB file

    Hi

    Okej it works just with one file

    If I have several files with different date and time

    how to get one of them back.

    file.mdb20130509_18:48

    file.mdb20130509_19:48

    file.mdb20130509_20:18

    file.mdb20130509_20:48
    Reply With Quote Reply With Quote
  7. May 9th, 2013, 03:17 PM #6
    Spoo
    Spoo is offline
    PowerPoster Spoo's Avatar
    Join Date
    Nov 2008
    Location
    Right Coast
    Posts
    2,656

    Re: MDB file

    Maybe you could put the files in a FileListBox.
    You could see what files are available and select the desired one from the list.
    Reply With Quote Reply With Quote
  8. May 10th, 2013, 12:16 AM #7
    Doogle
    Doogle is offline
    PowerPoster
    Join Date
    Jul 2006
    Location
    Maldon, Essex. UK
    Posts
    6,334

    Re: MDB file

    If I were you I'd use Rhino's suggestion for the file and append the Date and Time to the Filename rather than Filetype. That will make it (slightly) easier to filter if you're going to use a FileListBox.
    Reply With Quote Reply With Quote
  9. May 10th, 2013, 01:08 AM #8
    Bonnie West
    Bonnie West is offline
    Default Member Bonnie West's Avatar
    Join Date
    Jun 2012
    Location
    InIDE
    Posts
    4,060

    Re: MDB file

    Quote Originally Posted by Bonzo2008 View Post
    Hi

    Okej it works just with one file

    If I have several files with different date and time

    how to get one of them back.

    file.mdb20130509_18:48

    file.mdb20130509_19:48

    file.mdb20130509_20:18

    file.mdb20130509_20:48
    In addition to RhinoBull's and Doogle's recommendations, you also shouldn't use a colon (":") anywhere in the filename because doing so creates or accesses the Alternate Data Streams (ADS). See Streams for more info.
    On Local Error Resume Next: If Not Empty Is Nothing Then Do While Null: ReDim i(True To False) As Currency: Loop: Else Debug.Assert CCur(CLng(CInt(CBool(False Imp True Xor False Eqv True)))): Stop: On Local Error GoTo 0
    Declare Sub CrashVB Lib "msvbvm60" (Optional DontPassMe As Any)
    Reply With Quote Reply With Quote
  11. May 10th, 2013, 06:36 AM #9
    Bonzo2008
    Bonzo2008 is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 2011
    Location
    Greece
    Posts
    164

    Re: MDB file

    Quote Originally Posted by Bonnie West View Post
    In addition to RhinoBull's and Doogle's recommendations, you also shouldn't use a colon (":") anywhere in the filename because doing so creates or accesses the Alternate Data Streams (ADS). See Streams for more info.
    Hi

    I solved it
    Reply With Quote Reply With Quote
  12. May 10th, 2013, 07:23 AM #10
    SamOscarBrown
    SamOscarBrown is offline
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,622

    Re: MDB file

    REF: "I solved it"

    If so, please make this thread as RESOLVED, under 'thread tools'.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width