UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Custom Search
Edit Discussion
> Backup    
Backup

Image:NotifCleanup.gif This page requires general cleanup in formatting or text to better fit the UA Wiki Guidelines

If something goes Wrong (Crash,Corruption,Sharing)..you can Rebuild your Database from your Backup

Contents

Windows

  • Start > All Programs > Accessories > System Tools > Files and Settings Transfer Wizard
  • Start > Programs > Accessories > System Tools > Backup > Backup or Restore Wizard


Database

Type to Immediate window (VBE_Menu,Immediate Window )

CODE

For i = 1 To References.Count: Debug.Print i, References(i).Name, References(i).FullPath, FileDateTime(References(i).FullPath): Next i


Database Objects

CODE

' --------------------Example Call ----------------------
? SYS_AC_BackupAsText(bActionSave:=True)


Directory Tree

XCOPY


Office Settings

Start-All Programs-Microsft Office Tools- Save my Settings Wizard


Schedule Backup Task


Archive Files

Add to Archive

CODE

' SYNTAX:
? shell("D:\PathToMyRAR\RAR.EXE a D:\MyArchivePath\Archive.rar D:\MyDatabasePath\MyDatabaseName.mdb")
? shell("D:\PathToMyZip\7z.EXE a D:\MyArchivePath\Archive.zip D:\MyDatabasePath\MyDatabaseName.mdb")
? shell("D:\PathToMyZip\7z.EXE a D:\MyArchivePath\Archive.7z D:\MyDatabasePath\MyDatabaseName.mdb")
' EXAMPLE:
? shell("D:\_MOJE\_APL\Others\RAR.EXE a D:\TEMP\Archive.rar D:\_moje\_APL\AC\xPAC_DFT.mdb")
? shell("C:\Program Files\7-Zip\7z.exe a D:\TEMP\Archive.zip D:\_moje\_APL\AC\xPAC_DFT.mdb")
? shell("C:\Program Files\7-Zip\7z.exe a D:\TEMP\Archive.7z D:\_moje\_APL\AC\xPAC_DFT.mdb")

Extract from Archive

CODE

' SYNTAX:
? shell("D:\PathToMyRAR\RAR.EXE e -o+ D:\MyArchivePath\Archive.rar D:\MyArchiveExtractPath")
? shell("D:\PathToMyZIP\7z.exe e -aoa D:\MyArchivePath\Archive.zip -oD:\MyArchiveExtractPath")
? shell("D:\PathToMyZIP\7z.exe e -aoa D:\MyArchivePath\Archive.7z -oD:\MyArchiveExtractPath")
' EXAMPLE:
? shell("D:\_MOJE\_APL\Others\RAR.EXE e -o+ D:\TEMP\Archive.rar D:\TEMP")
? shell("C:\Program Files\7-Zip\7z.exe e -aoa D:\MyArchivePath\Archive.zip -oD:\TEMP")
? shell("C:\Program Files\7-Zip\7z.exe e -aoa D:\MyArchivePath\Archive.7z -oD:\TEMP")


Others

Edit Discussion
Custom Search
Thank you for your support!
This page has been accessed 20,558 times.  This page was last modified 16:52, 11 February 2012 by Jack Leach. Contributions by pacala_ba  Disclaimers