I currently have 2 oracle databases that my access database is going
to gather data from. The IT department wants to give me data snaps in
the form of a flat file. They will FTP the flat file to the location
that I need and I am wondering how I would be able to check to make
sure that the flat file is in the correct location before I
automatically append it to an access table. Basically, I am
attempting to have some automatic validation so that the user of the
system will recieve a message to contact IT if the file is not there.
Any ideas on the process.
Thanks