Backup - Access wiki - Access Help and How-to - Microsoft Office by UtterAccess.com

Follow @UtterAccess

Home

Welcome Guest ( Log In | Register )

Access wiki - Access Help and How-to - Microsoft Office > Viewing Backup

Content

Home
Articles
Function Library
Class Library
API Declarations
Error Codes

Resources

Wiki FAQ
Wiki Help
Markup Listing
Guidelines
Templates

To Do

Completion Required
Review Required
Wanted Pages
Dead End Pages

Toolbox

What links here
Related changes
Upload file
Special pages
Printable version
Permanent link

Backup

Options

Backup

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

1 Windows
2 Database
3 Database Objects
4 Directory Tree
5 Office Settings
6 Schedule Backup Task
7 Archive Files
- 7.1 Add to Archive
- 7.2 Extract from Archive
8 Others

[edit]

Windows

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

[edit]

Database

Be sure you have a plenty of YOUR_DATABASE BACKUPs.
- Ac_Menu,Back Up Database...
  - Startup-Set Default Backup Location
  - Startup-Verify Folder Size
Ac_Menu,Documenter and than Ac_Menu,Export...
It is better to create your Custom Toolbars/Menus with Code (from Visual Basic)
References (VBE_Menu,References... )

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

[edit]

Database Objects

Backup Database Object as TEXT: SaveAsText (MDB -> TXT) , LoadFromText ( TXT -> MDB )
- Syntax: VBE_Menu,Object Browser (F2), Show Hidden members=ON..
- Sub SaveAsText(ObjectType As AcObjectType, ObjectName As String, FileName As String)
- Sub LoadFromText(ObjectType As AcObjectType, ObjectName As String, FileName As String)
Backup ALL Database Objects as TEXT: Media: SYS AC BackupAsText V12.zip and than Rebuild-Database

CODE

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

[edit]

Directory Tree

XCOPY

[edit]

Office Settings

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

[edit]

Schedule Backup Task

Windows Startup

[edit]

Archive Files

Library VBA / Shell, Rebuild-Files from Archive

[edit]

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")

[edit]

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")

[edit]

Others

Getting Ready To Backup An Access Database (97 upwards)
Or look at some other Links

Retrieved from "http://www.utteraccess.com/wiki/index.php/Backup"

Categories: Access Wiki Index | Table of Contents | Content for Cleanup

This page was last modified 11:50, 23 January 2012. This page has been accessed 6,429 times. Disclaimers