CVS Folder --> P2Rx-Programs-Admin Files that are updated --> add1b.cfm, addNewOrg.cfm, delete.cfm, dummyOrganization.cfm, KeepCurrentDate.cfm (NEW) lists.cfm ProgramsDBUpdate.cfm (NEW to make necessary changed in our programs database) CVS Folder --> P2Rx-Programs Files that are updated --> act_finalprocess.cfm application.cfm dsp_editcontact.cfm dsp_addservices.cfm act_addProgramTypes.cfm act_addServices.cfm dsp_addprogramtypes.cfm dsp_editservices.cfm dsp_deitProgramTypes.cfm dsp_editOrganization.cfm dsp_addOrganization.cfm dsp_addnewContact.cfm DIRECTION (NOTE: IF YOU NEED HELP IMPLEMENTING ALL THESE FEEL FREE TO CALL ME BECAUSE SO MANY CHANGES ARE MADE) 1. Update "p2rx-programs-admin" and "p2rx-programs" directory from CVS 2. Retrieve ProgramDBUpdates.cfm from "p2rx-programs-admin" directory on CVS 3.Retrieve Programs Database from your server. We will need to delete the dummy tables we created previously. I would definetly make a backup of those tables before you proceed to the next step. 4.Please put back the database in the server. 5.Visit that file via web browser 6.Click on link ensuring all steps have completed successfully 7.Open Programs Database 8.Open dOrganization in design view, change the following columns' "Allow Zero Length" property to 'Yes' - Division Address2 Phone Extension HotLine FaxNumber EmailName GraphicURL Progress Times 9.Highlight the "UpdateStatus" field. In the Properties Box, place a zero (0) in the "Default Value" field 10.Click Save 11.Change dOrganization to Datasheet View, find "UpdateStatus" field and place a zero there for all the records 12.Open dContacts in design view, change all of the columns' "Allow Zero Length" property to 'Yes' Once you replace all the above listed files, everything should work like how we all want it.