Autmating File Maintenance

[bxm]

Hi,

My company is running FM7. To maintain the files, I come in after hours every few weeks, open the files in Developer 7 and run the File Maintenance feature.

Is there a way to automate this type of file maintenance?

[Genx]

Im not really sure its necessary to be doing it that often...

[Wim Decorte]

how often depends on the amount of data manipulation that is going on. But there should be some frequency in doing it.

You could automate it by writing something in VB or VBscript and use the SendKeys method, but the real work would go into checking that the files are not being hosted, if they are that they are closed properly before doing this, etc.