Viewing 3 posts - 1 through 3 (of 3 total)
I would move the data and saved queries (views) to SQL Server - not easy but would solve the issue.
If you need to leave the data in Access - then...
November 14, 2007 at 1:39 pm
#751252
Can you run the query from the data tab?
November 14, 2007 at 1:18 pm
#751240
never mind....i found this in another forum.
EXEC msdb.dbo.sp_start_job @job_name=N'DA5D631A-888F-4705-8003-1799B22BC321'
works great.
November 14, 2007 at 1:16 pm
#751239