Exporting to a Common Database File

Exporting the contents of several systems on a network to one database is easy. You can simply save the file to the same database and it will automatically add to the existing data or append the data if that particular machine has already exported before. 

How Cool Info XP exports the data
When Cool Info XP runs for the first time it creates a unique system key that allows it to identify each system. When exporting to a common database file it uses this key as the Primary Key. This allows the data to be added to a database without overwriting another systems data. This also allows the data for a particular system to be appended. 

Automatically have the data exported to a database file when the computer is rebooted
Cool XP info allows you to automatically export the data from each machine on a network each day when the computer is rebooted. This can be done by using a simple logon script that checks to see if Cool Info XP is installed (if not it installs it) then exports it to the database.


@ECHO OFF
rem The following checks to see if Cool Info needs to be installed, if it is, then an export is performed
rem Change the last path to match where you have the Cool Info installation located
If not exist c:\progra~1\Creation\CoolInfo\CoolInfo.exe
\\myserver\myshare\install_location\setup.exe /S
If exist c:\progra~1\Creation\CoolInfo\CoolInfo.exe coolinfo.exe /O /Q /D /F:\\myserver\myshare\allmachines.mdb



TIP:

When using Microsoft Access be sure to Compact and Repair the database often, especially if it is used regularly, to avoid large file sizes.