Upgrading older datafiles

If you have not yet changed/added any data.

• Simply replace your existing ZDN program and files with the new versions
  • Remove both the old version and the ZDN Support Files folder
  • Download new version
  • Follow original installation instructions

If you HAVE entered data about your zoo, feeds, animals, or diets...

*New* for version 2.1:

1. Enter "Alt-F11" to open up the VBA editor.
2. Enter "Ctrl-G" to go to the "Immediate Window"
3. Paste the following lines of code one-at-a-time into the Immediate Window and hit <Enter>. Nothing will (apparently) happen, but this will update your tables.

CurrentDb.TableDefs("Animals").Fields("Current").Name = "Active"

CurrentDb.TableDefs("Diet Table").Fields("Current").Name = "Active"

4. Continue with the "All Versions" instructions below.

Upgrading all versions:

• Download the newest ZDN version and follow the "Install" section (only) of the Installation instructions to setup. Do not open ZDN yet.
• Copy your OLD ZDN datafile from your [old location] > ZDN Support Files > Datafiles > your_datafile_name.accdb into your new ZDN Support Files > Datafiles folder
• Open up your datafile from the NEW location (located inside ZDN Support Files > Datafiles)
• Paste in the table below and click "Update"

ANIMALS	ParkID	INTEGER
PARKS	ZIMS_Park_Name	TEXT
GOALS	GoalID	INTEGER
GOALS	GoalCategory	TEXT
GOALS	GoalTitle	TEXT
GOALS	GoalDescription	TEXT
GOALS	GoalStartDate	DATE
GOALS	GoalEndDate	DATE
GOALS	DietID	INTEGER
NUT_DATA2	QualityIndex	INTEGER
SPECIALORDERS	DIETID	INTEGER
SPECIALORDERS	FOODID	INTEGER
SPECIALORDERS	GROUP_AMOUNT	DOUBLE
SPECIALORDERS	UNITID	INTEGER
SPECIALORDERS	Prep_Loc	INTEGER
SPECIALORDERS	LINENOTES	TEXT
SPECIALORDERS	OrderDate	DATE
SPECIALORDERS	OrderBy	TEXT
SPECIALORDERS	CreatedOn	date
SPECIALORDERS	RequestedBy	TEXT
SPECIALORDERS	Reason	TEXT
SPECIALORDERS_PAST	DIETID	INTEGER
SPECIALORDERS_PAST	FOODID	INTEGER
SPECIALORDERS_PAST	GROUP_AMOUNT	DOUBLE
SPECIALORDERS_PAST	UNITID	INTEGER
SPECIALORDERS_PAST	Prep_Loc	INTEGER
SPECIALORDERS_PAST	LINENOTES	TEXT
SPECIALORDERS_PAST	OrderDate	DATE
SPECIALORDERS_PAST	OrderBy	TEXT
SPECIALORDERS_PAST	CreatedOn	date
SPECIALORDERS_PAST	RequestedBy	TEXT
SPECIALORDERS_PAST	Reason	TEXT
FEEDINGSCHEDULES	DIET_SUB_ID	INTEGER
FEEDINGSCHEDULES	F_Orig_Avg_Daily_g	INTEGER
FEEDINGSCHEDULES	F_FOODID	INTEGER
FEEDINGSCHEDULES	F_UNITID	INTEGER
FEEDINGSCHEDULES	F_IND_AMOUNT	DOUBLE
FEEDINGSCHEDULES	F_GROUP_AMOUNT	DOUBLE
FEEDINGSCHEDULES	F_SU	YESNO
FEEDINGSCHEDULES	F_M	YESNO
FEEDINGSCHEDULES	F_T	YESNO
FEEDINGSCHEDULES	F_W	YESNO
FEEDINGSCHEDULES	F_R	YESNO
FEEDINGSCHEDULES	F_F	YESNO
FEEDINGSCHEDULES	F_S	YESNO
FEEDINGSCHEDULES	F_FRQ_WEEKS	INTEGER
FEEDINGSCHEDULES	F_FRQ_ROTATION	INTEGER
FEEDINGSCHEDULES	F_Feed_Avg_Daily_g	DOUBLE
FEEDINGSCHEDULES	F_Matches_orig_amt	YESNO
FEEDINGSCHEDULES	F_FeedingCategory	TEXT
TBLANIMALENCLOSUREHISTORY	DietChangeDate	DATE
TBLANIMALENCLOSUREHISTORY	DIETID	INTEGER
TBLANIMALENCLOSUREHISTORY	AnimalGAN	TEXT
TBLANIMALENCLOSUREHISTORY	EnclosureID	INTEGER
TBLANIMALENCLOSUREHISTORY	Type	TEXT
TBLANIMALENCLOSUREHISTORY	AnimalUnits	DOUBLE
RECIPEINGREDIENTSTABLE	IngredientNote	TEXT

If you have made changes to forms and reports...

Please keep a list of the items you have modified.

1. Open up the new ZDN_vX.X.accdb file
2. Delete the reports that you have modified
3. Open up your existing (previous version) ZDN_vX.V.accdb datafile
4. Copy the reports from X.V (yours) to X.X (the new one).

Important Note: If your datafile was created prior to v1.9.4...

Contact Heidi for assistance upgrading your datafile.