Selection of 'backup and delete' on the switchboard will allow the user to archive (backup) their data, or remove blocks of records from the database.
Export (Backup)In past decades, much archaeological data have been lost due to storage on media no longer accessable, or in formats no longer readable. Because of this, it is safest to reduce data to an easily readable format. It is possible to export data to a variety of file formats using Access' inbuilt features, but users may prefer to use this backup option for ease and convienence. It creates a series of comma-separated text files (.txt), one per table (see the navigation and structure page for definitions). These text files can then be viewed with only minimal software, such as Notepad or WordPad, and can be imported into a variety of other programs, including other database systems. Their other advantage is that each file is extremely small in size and will easily fit on floppy disks, unlike the actual database file.
The backup files created will be placed in a folder called 'backup', located in the same directory as the main database file. A blank file of this name is included on the CD, although if it is missing, a new one can be easily created in the normal way. Once the files have been created, that folder can be moved, copied, renamed, etc.
Four types of tables can be backed-up, as illustrated at left. The 'main' tables are those which contain most of the data entered by the user, the 'measurement' tables are self-evident, and the 'lookup' tables are those that contain lists of species, elements, etc. The system tables contain technical information and are created and maintained by Access itself. Most users will probably wish to create backups of the first two types of files, as those will contain all the data recorded about all specimens. However, if the user has customised several of the lookup tables, they may wish to preserve their changes by saving copies of these as well. Finally, the system tables can be saved if desired, as they contain all the data relating to the structure of the database itself; these data can then be used to completely reconstruct the basic database. Only experienced database designers need bother with this option.
In the unlikely event of either the York System or Access itself becoming corrupted, these backup files can then be imported manually into a fresh version of The York System, using File | Get External Data | Import... .
Delete