Currently running A2007 (using 2000 mdb format). Have created a simple query with three linked SQL tables. Query has no criterias. Created a report a report to show the data from the query. Created a macro to sendobject (report) as an snp using outlook. When I run the macro in access the process runs fine and opens outlook with the report as an snp attachment. The report is composed of 5 pages. But when I try to run the macro thru Windows Scheduled Task I get the "No Current Record." message. I have to click ok approx 5 times in the error message and then Outlook opens with the attachment but when I open the attachment it only shows the 1st page correctly, the 2nd page shows all fields with #Error.
I have compacted/Repaired the db, I created a new db and moved the database to different servers and still get the same error message when ran from the scheduler.