IntelliTrack Inventory Management - Manual (Page 344)

I NTELLI T RACK I NVENTORY V 8.1
User Manual
318
Cautions when Customizing IntelliTrack
If you have the appropriate version of Microsoft Access, you can modify
the IntelliTrack database structure.
Caution:If you are not familiar with Access, complete the tutorial provided
with Access before making changes to the database.
While IntelliTrack fully supports its products, we are unable to provide
free support if you modify your system (as it is now a custom system).
Should you need assistance modifying the Inventory program, contact Int-
elliTrack Software Services or request a list of qualified service providers
that can offer customization services or you may contact Microsoft for
Access related questions.
1. When customizing a system, it is a good idea to create a separate direc-
tory for the customization. Modify and test the modifications here with-
out disturbing the original application. Copy the application to that
directory (in this case ITRAK.ACCDB) and any databases used for
attached data files (i.e. DATAINE.MDF). If you do this, you must reat-
tach Inventory to the correct data files. This process provides a safe
location and sample data for modifications and testing.
2. Once the modifications and testing are complete and working as
expected, replace ITRAK.ACCDB on all workstations with the modi-
fied version.
3. IntelliTrack may modify some of the main tables (Inventory, Bin
Location, and Inventory by Location) in future releases. Therefore,
we advise that you create custom queries/tables and use these new
objects when creating custom forms/reports, etc. Whenever you create
a new report, form or query, it is highly recommended that you save
new objects with unique names. This ensures that no changes will get
overwritten in future IntelliTrack updates and upgrades.
4. IntelliTrack uses a separate database file for its shared tables so that
custom data does not get overwritten during updates. To modify this
table, open the ITRAK.ACCDB file. Attached tables have an arrow
next to the table name when viewed from the navigation pane.
5. New objects are stored in the ITRAK.ACCDB file. Keep a backup of
the entire Inventory directory to ensure data integrity and save custom
modifications. When upgrading, copy the ITRAK.ACCDB file to
another directory and import the custom objects from the copied file
into the updated version of Inventory.
2287.book Page 318 Thursday, July 7, 2011 4:45 PM