Marc - I usually create a menu choice for the user to "Install Program Updates". This menu choice always looks for a special file, Install.sms, to run.
For your example, just unload the forms and reports to files (use the right-click option in the Database Explorer, and it will add the line "DROP REPORT whatever" to the top of the file so that the old report or form will be deleted before the new one is loaded). Create your special install file as this simplified version shows: SET NULL -0- SET MESSAGES ON SET ERROR MESSAGES ON CONNECT databasename --If not already connected via your menu RUN form1.frm RUN form2.frm RUN report1.rpt RUN report2.rpt DELETE form1.frm DELETE form1.lob DELETE form2.frm DELETE form2.lob DELETE report1.rpt DELETE report1.lob DELETE report2.rpt DELETE report2.lob RETURN Then zip up the forms and reports files along with the install file and have the user unzip them to the database folder. They then run your program normally, and select the "Install Program Updates" option. To get more complex, add an error check as the file is installed and delete or replace the original Install.sms file after the user has successfully installed it. Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Sent: Monday, October 31, 2005 11:26 AM To: RBG7-L Mailing List Subject: [RBG7-L] - updating users Hi I have several out of state users and was wondering what is the best way to update their forms and reports. Thanks
