June 12, 200619 yr 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.
June 12, 200619 yr This can all be achieved with OS-level scripting and integrating that with FM. Check ou the "Windows Automation" forum for some more info.
June 12, 200619 yr 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
Create an account or sign in to comment