Results 1 to 6 of 6

Thread: Access backup

  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Swift Current, Sask. Canada, Saskatchewan, Canada
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access backup

    Just new to Access. Created a data base, but have not been able to figure how to back it up to a floppy. Any help really appreciated.

  2. #2
    Mike B
    Guest

    Re: Access backup

    use windows explorer when your db is closed....take a copy and paste it to the floppy HTH

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access backup

    I would also add that it (always) helps to compact the database before copying to the floppy. The database gets bloated as it is used and compacting purges any temporary objects and makes the file as small as possible - short of using compression (like ZIP).

    Access 97: Tools|Database Utilities|Compact Database
    Access2000: Tools|Database Utilities|Compact and Repair Database...

    HTH

    -MarkJ-

  4. #4
    Robin_Freestun
    Guest

    Re: Access backup

    Hi
    You should be aware that unlike a word document or spreadsheet the database isn't just loaded into memory so you can save it anywhere you like. The database is created when you begin, and the data is written directly to the disk. Everytime the little pencil on a dataform or in a table changes back to the right-pointing thick arrow your record has been saved to disk. (You do need to save table definitions, form layouts etc., but not the data).
    Because of the way Access works, you can't just 'save as' the database to another location.
    You must use Explorer to copy the database, and as mentioned by Mark, you should Compact the database first to significantly reduce the size (sometimes [img]/w3timages/icons/smile.gif[/img])
    Good luck. I was a new Access user not so long ago.
    Regards, Robin

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access backup

    This maybe better if the original and copy remain in their same relative positions. Create a batchfile ".bat" that will copy the .mdb file from source to backup folders. Create a form in access in design mode and add a command button. in the onclick event of this button put the code:
    'Shell "mypathnamemybatchfilename"'.
    whenever this button is clicked the batchfile will run and copy the database to the desired location. YOU DO NOT NEED TO CLOSE THE DATABASE TO RUN THIS.
    HTH[img]/w3timages/icons/cool.gif[/img]

  6. #6
    Robin_Freestun
    Guest

    Re: Access backup

    Good thinking father! [img]/w3timages/icons/shocked.gif[/img] I've gone round and round the idea of backing up by code (Creating an empty database etc, and exporting tables and forms etc. but the links all break!!) Batch is best (AND simple)! Robin

Posting Permissions

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