On a more general theme, the request is for how to automatically detect the presence of a new file when dropped in a folder. There is no 'automatic' way to do this but there are two ways it can be coded:
1. Keep a list of files and compare it to the ones in the folder. If one is not in the list, add it to the database then update the list to include it.
2. Keep a record of the timestamp (creation date/time) of the latest file in the list. Keep checking for a later timestamp which would tell you the file was added more recently than when last checked.
The first method might involve long lists but maybe these are available in the database already. The second method is quicker beause only one file is checked at a time and only one variable is compared but might be confused if a file is added with an incorrect timestamp.
Brian.