Establish a robot process that automatically runs your routine every night. Have your routine maintain a last packed field in the table that lists the tables your code maintains. Have your process send an Email to the users whose sessions are holding files open explaining why it is important for them to close the application. Finally have your process Email a report to someone who can do something about files that have not been packed for X days. You may want to have the system track who the "forgetful" users are.
HTH - Joe Yoder On Tuesday, April 08, 2008 6:25 AM, Alan Bourke wrote: > >Date: Tue, 08 Apr 2008 11:25:36 +0100 >From: Alan Bourke >To: [EMAIL PROTECTED] >cc: >Subject: Re: User Disconnect > >On Mon, 07 Apr 2008 15:53:53 -0400, "Randy Joles" <[EMAIL PROTECTED]> >said: > >> I do have the source, but I'm dealing with almost 8000 tables and 3200 >> prg files. How would you handle this? Thanks >> > >Well, I guess most people would have a maintenance routine within the >product, and educate users to run that routine periodically, and also to >close the application when finishing work. I appreciate that this may >not apply to your situation. Apart from anything else, is it getting >backed up properly if files are open all the time? > >Maybe, if you have a copy of FoxPro/DOS or Foxpro for Windows you could >write a seperate EXE that would iterate through all the tables, attempt >to open each. If opened, do a pack/reindex, otherwise skip. If you could >find a way of running that periodically it would eventually manage to do >all the tables. >-- > Alan Bourke > [EMAIL PROTECTED] > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.