Import with File Size & Name

[JP2004]

I have a small database that I use to keep scanned copies of documents i need to archive. At the moment i am able to import the files as pictures and using the file name can perform various activities with external applications etc. However i would like to be able to do the following:

Import the file size with the image (this is so that i can screen erronous images)

Atuomatically delete records based on date i.e. after 1 month from date of import.

When deleting the records from the database delete also from the computer.

I realise that the last two are not really for this particular forum but i guess they do have a relavence as i am sure others may find such functionality usefull for archiving purposes.

Thanks in advance to anyone who can help me.

p.s. if need be i can attach the database to a post if it makes a difference.

[Wim Decorte]

This can all be achieved with OS-level scripting and integrating that with FM. Check ou the "Windows Automation" forum for some more info.

[Lee Smith]

Import the file size with the image (this is so that i can screen erronous images)

Have you tried using the Get ( FilePath ) and Get ( FileSize ) for referenced files?

Lee