Connecting Tech Pros Worldwide Forums | Help | Site Map

Email Access Report based on a Pass-thru query to Oracle

Newbie
 
Join Date: May 2007
Posts: 1
#1: May 18 '07
I am trying to e-mail reports from Access that are based on pass-through queries going to an Oracle database. I am using Access 2003 on a Windows XP OS. I was able to e-mail these on my previous PC which used Windows 2000. I can e-mail reports from the same database that point to queries that reference local tables (not linked Oracle tables and not pass-through queries). I am e-mailing either by using File, Send To or by using the Send Object method in a Macro. What am I missing? Is there a Reference I need to set-up?

Thanks very much!
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,722
#2: Jun 2 '07

re: Email Access Report based on a Pass-thru query to Oracle


There's not too much to go on here.
What format are you e-mailing the reports that do work?
I'm afraid I can't think why an Oracle pass-thru would behave differently from the others but there's so little here even in the way of clues, so I don't know if I might notice something with more to work with. I certainly can't promise results but I'd think on it.
Reply