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
Thanks,
Jim Reece