We have a system who storing files on a local server, where a part of the filenames contains an unique 8 char code.
This unique 8 char code is also stored in an access database.
Now I search for a function who:
1. On a click, makes this Access database connect to this local server through FTP (yes, ftp is a must).
2. Check if there is a filename having this unique 8 char code.
3. Tell Yes if the file exists, No if it doesn't exist.
And an overkill, but very useful if above is very easy:
4. If yes, click again and the file are transferred and runs with the computers associated software.
Is this possible? How do I do :)