Run Query and FTP Table To External Server

jereece

Registered User.
Local time
Today, 20:11
Joined
Dec 11, 2001
Messages
300
I have an Access query that copys certain data from an SQL database and I have reports, etc. I view. I would like to have access to this data at home, unfortunately the SQL data is not available to me at home. I was thinking if I had a way to automatically run my Access query once an hour at work, then FTP the table it creates to a remote server, I could set up an ASP file to view the data. My problem is (1) how to get the Access query to run hourly as long as my machine is running at work and (2) how to automatically FTP this data or the whole Access file to my remote server (which I already have). Does anyone have any ideas? or is there a better way?

Thanks,
Jim Reece
 
Better way: Do an asp page on the sql server direct...

1) Use the on timer event of a form to find out (every minute) it its a certain minute of the hour (lets say 00) then do some stuff to export and ftp...

2) I posted an example here or did you try a search? It returns 96 threads in which you can find what you want (including my example)

Regards
 
Can no do. My IT folks won't allow it. So I am still back to finding a way to run the query on time and FTP to external server.

Any other ideas?

Thanks,
Jim
 
Try re-reading my post and NOT stopping after the first line, I posted a good option ... My 1 and 2 match your 1 and 2.

Regards
 

Users who are viewing this thread

Back
Top Bottom