Results 1 to 3 of 3

Thread: copying backend

  1. #1
    Mike B

    copying backend

    hi all.... i am trying to figure out if it is possible to have a a command button that will select the backend db of the current db.....copy it and then send it to either the floppy disk or to a zip drive.....anyone ever done this???

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Indianapolis, Indiana, USA
    Thanked 0 Times in 0 Posts

    Re: copying backend

    Hi Mike, you can use the FileSystem object in VBA to copy the file to a selected destination:
    <pre>FileCopy("NetworkPathBackend.MDB","H:Backup.M DB")</pre>

    (or whatever the applicable filenames are)

    You can also use the commandline add-on with WinZip to have it zip and save the backend to a specified location (if you want it zipped). For that, you can use the Shell command:

    <pre>Shell("WZZIP ....",vbHide)</pre>

    I'm not sure of the exact syntax for the Winzip commandline process - you can read about it in the helpfiles.

    Hope this helps....

  3. #3
    Mike B

    Re: copying backend

    thanx Mark *S*

Posting Permissions

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