|  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 

Advantage Help > Options > Maintenance

Maintenance Settings

Backup Folder, Restore Folder

You can check the backup and restore folders, which are utilized by the backup and restore procedures.

To view the backup files, you can open File Explorer and navigate to the backup folder.

File Storage Mode

In Organizer Advantage, you can use both attachment and image data fields. The File Storage Mode option determines how the application manages these files. When the "Store Centrally" option is selected, and you link to an image or attachment file, the program will copy the chosen file to the designated "central" folders.

• Images will be copied to C:\your_adv\data\db\img\
• Attachments will be placed in C:\your_adv\data\db\attach\

In this scenario, the image and attachment data fields will only store the file names without the complete file paths. If you intend to include images and attachment files in your backup, ensure they are stored in the "central" folders.

Store Graphic Files Centrally in DATA Folder
Store Attachment Files Centrally in DATA Folder

• When images or attachments are stored in the default folder, they can be included in the backups.
• Files that are not in the central storage will not be backed up.
• Note that if the full file name exceeds the maximum field size, it may not be stored correctly.
• Additionally, in a network environment, users from different computers can upload images, which will be stored and displayed correctly.

Usage Examples

Store Graphic Files Centrally in DATA Folder
In this example, car images are displayed in the image data field (labeled PICTURE). When an image is selected, the program copies it to the ..\data\db\img\" folder.

Store Graphic Files Centrally in DATA Folder, selected

Images are stored in the C:\adv_collect\data\db\img\

Only file names stored in the PICTURE (no path)

Store Attachment Files Centrally in DATA Folder
In this example, links to PDF and text files (labeled BOOKFILE) are stored. When a file is selected, the program copies it into the "..\data\db\attach\" folder.

Store Attachment Files Centrally in DATA Folder, selected

Attachments are stored in the C:\adv_book\data\db\attach\

Only file names stored in the BOOKFILE (no path)

DO NOT Store Centrally
If you do not select the "Store Centrally" option, the image and attachment fields will store both the file name and its path.

Organizer Advantage, Simple Database Solutions for Windows PCs

Organizer Advantage, Business Database Solutions for Windows PCs

Organizer Advantage Free Service

Organizer Advantage Support

Database Blog:
Advantages of Database Software over Spreadsheet Applications
Firebird SQL Tutor
Custom Wine Inventory Database

Free Database Templates