There have been many suggestions on the UT in the past regarding this including how to remotely close out your users' apps if left open when the scheduled time arrives. You might try a search on the UT to see all of the suggestions.

One I did myself involved two parts.

The first part was a table that stored the days, dates, times, etc of the scheduled event. The main app checks for the values periodically via a timer on the main apps toolbar and when the date/time is reached, it prompts the user to exit the app and if the user does not exit, it closes all files and exits. It then sets a 'switch' in the table that no one can run the app and if a user trys to start the app again, they receive a message stating that maintenance is running and to try later. This of course means the time must be during off-time hours or else the users will be forced out of the app during business hours (yuck).

The 2nd part involved one of two options.

You can write a separate app that checks for exclusive use of the tables and when successful, runs the maintenance routines. This app can be called via the windows scheduler. The scheduled time should be within a reasonable time from the table value to allow the app time to get the users out of the system if they left work with their machine running and the app open.

Or you can have your main app close all tables and call the 2nd app when the date/time arrives but then your main app must be running on at least one machine continously for this to work. The main app then must have its own timer to check the date/time against the value in the table.

There were other (much better) options out there in the UT threads you will find if you search.

Tracy

>Hi. One of my clients has requested that we allow pack/reindex to be scheduled (to that I think they mean allow WIndows to run pack/reindex on the application while outside of the application). Can this be done, and if so how? (We are using VFP7, Visual Extend and Stonefield and clients run of Win98, Win2000 and WinXP Pro, peer-to-peer or with Win2000 Server)
>
>TIA
>
>Sandi