Re: IIS & SQL Server 7

From: Mark Taylor (anonymous_at_devdex.com)
Date: 04/26/03 

Date: Fri, 25 Apr 2003 15:59:47 -0700

Mike, thanks for your help. This works well for me but it won't solve my
problem in the long run. The application I'm building enables a user to
request a report that consumes a lot of processing time, i.e., requires
background processing. I will need to access a user record so that an
email address can be formed. I'll then run a com object that will use
DTS objects to build the report and email the report to the requestor.
Using the anonymous login isn't going to work unless I make the
requestor key in their email address. ok for the short run but it won't
do for the long run.

Mark "What? Me worry?" Taylor

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Email Report - Using a Field on Report as TO
    ... use a "lastname, firstname" format. ... Is there a way to convert that submitter field so that it ... you can use DLookUp to fetch the requestor name from the same query that ... DoCmd.SendObject acSendReport, "name of report", acFormatText, strTo... ...
    (microsoft.public.access.reports)
  • Re: Email Report - Using a Field on Report as TO
    ... I would use VBA instead of a macro. ... Assuming the report is based on a query, ... can I send a report using the requestor name field ...
    (microsoft.public.access.reports)
  • Re: List of Direct and Indirect Reports
    ... How do we know which group each member is in?? ... matter to use data>filter>autofilter>filter by group number or letter. ... requestor wants to see everyone in so and so's group. ... places a report like Fig 2 on sheet2 of the workbook. ...
    (microsoft.public.excel.programming)
  • Re: Help with Access Query Condition
    ... If the fields Requestor(?) CallType, and Closedare never null you can ... > 3 filters and I want to be able to pull a report depending on what the ... > chooses to filter the report by. ... the filters on the form are ...
    (microsoft.public.access.queries)
  • Re: Speeding up report printing
    ... > Another idea is to store the results of your query in a temporary ... then run the report from that table. ... >> minutes for the queries to run, then I can Preview the report. ... you double the processing time on the report. ...
    (microsoft.public.access.reports)