Try issuing a DIR or ls to the remote FTP server once you log in.  You can then parse the result to get the date of the file.

You need to enclose the path in quotes:

"C:\Documents and Settings\datamining\My Documents\loadfile.bat"

its possible that you don't have permissions to read the registry key itself.  I'm not sure how to set permissioins up, but there are permissions in the registry similar to...

Sounds to me like your email server is the one thats not letting the mail get sent.  can you have your admin add the email address you are sending from...

add some vb code to your report that sets up two functions and one counter.  something like this:

dim MyCounter as integer

public function ResetMyCounter()

MyCounter = 0

end function

public function GetMyCounter()

MyCounter = MyCounter...

Morten's got it right, a big old batch file is needed to do the actual work.  But take it a step further, put your server names in a table and...

open a new Visual Basic 6 project

add a component from the Project/Components menu Microsoft Internet Controls

   this will add a web browser component to your toolbar

put the new WebBrowser component...

I know a guy in denver that his company is using Kerberos to do that kind of authentication.

There are some error messages you just can't grab.  How about this idea, using a stored procedure write a batch file based on the list of servers that you need to query...

Use an old fashoned DOS command line trick:

echo y | rskeymgmt -e -f SRSKey -p password > extract.log 2>&1

The echo sends a Y character into the standard input and answers...

add a new form to your app, put a browser on it and navigate to the reports.  you can fill in parameters in a query string on the URL to...

You may have to create a seperate access database, populate the tables, then close that database and call the DTS package.  DTS doesn't like to work with files that are...

Nice!! Very Nice!  Thanks!

Have you looked into using Transactions?

on my 2000 install its in C:\Program Files\Microsoft SQL Server\80\Tools\Binn\RSConfig.exe