Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Report v slow to open in Excel using OutputTo

Discussion in 'Information Technology' started by Liz James, Nov 5, 2005.

  1. Liz James

    Liz James
    Expand Collapse
    Guest

    Using OutputTo open reports in Excel. Office 2003, Access 2003.

    Opening report in Excel from Access is very slow for whichever report is
    opened first. Once the database is open and at least one report has been
    opened, subsequent reports open within a couple of seconds. That first report
    to open takes up to 2 minutes to open. I have tried opening Excel separately
    before opening the first report, but it makes no difference to the time
    taken.

    I have not found any questions relating to this on the discussion group. Do
    others experience this sluggishness? Is there something that I am missing
    here?

    The code I am using is below.

    DoCmd.OutputTo ObjectType:=acOutputQuery, ObjectName:="ReportCostsCondn3", _
    OutputFormat:=acFormatXLS, AutoStart:=True
     
  2. Loading...

    Similar Threads Forum Date
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014
    Legal ACLU reports: Judge orders Sikh man, "Remove that rag, or Go to Jail! Breaking News Sep 27, 2013

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Try turning off your AntiVirus software and see if it helps. If it does, you
    may need to contact the vendor to see if he has a patch.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Liz James" <LizJames@discussions.microsoft.com> wrote in message
    news:684537C4-31CD-4EA9-AD15-9B1E05B9FD8F@microsoft.com...
    > Using OutputTo open reports in Excel. Office 2003, Access 2003.
    >
    > Opening report in Excel from Access is very slow for whichever report is
    > opened first. Once the database is open and at least one report has been
    > opened, subsequent reports open within a couple of seconds. That first

    report
    > to open takes up to 2 minutes to open. I have tried opening Excel

    separately
    > before opening the first report, but it makes no difference to the time
    > taken.
    >
    > I have not found any questions relating to this on the discussion group.

    Do
    > others experience this sluggishness? Is there something that I am missing
    > here?
    >
    > The code I am using is below.
    >
    > DoCmd.OutputTo ObjectType:=acOutputQuery, ObjectName:="ReportCostsCondn3",

    _
    > OutputFormat:=acFormatXLS, AutoStart:=True
    >
     
  4. Liz James

    Liz James
    Expand Collapse
    Guest

    Spot on, Arvin. Many thanks.

    If someone uses the database on a corporate computer and has the same
    problem, but is totally unable to turn off the virus monitoring because the
    corporate network is so tightly controlled form head office, is there
    anything else that can be done to speed up opening the first report each time?

    "Liz James" wrote:

    > Using OutputTo open reports in Excel. Office 2003, Access 2003.
    >
    > Opening report in Excel from Access is very slow for whichever report is
    > opened first. Once the database is open and at least one report has been
    > opened, subsequent reports open within a couple of seconds. That first report
    > to open takes up to 2 minutes to open. I have tried opening Excel separately
    > before opening the first report, but it makes no difference to the time
    > taken.
    >
    > I have not found any questions relating to this on the discussion group. Do
    > others experience this sluggishness? Is there something that I am missing
    > here?
    >
    > The code I am using is below.
    >
    > DoCmd.OutputTo ObjectType:=acOutputQuery, ObjectName:="ReportCostsCondn3", _
    > OutputFormat:=acFormatXLS, AutoStart:=True
    >
     
  5. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Some vendors have a patch. You might also exclude databases from the list of
    items that the AV checks.

    One other thing: Access is one of the few Windows programs that uses a
    header file to open, so it doesn't really care what the extension is. You
    can create an extension like: northwind.liz and register the extension to
    open with Access and it will do it. So you can have the AV still test all
    the mdb's but ignore the liz's. Since there will be only a few files with
    that extension and no virus writer can anticipate what it will be, you'll be
    safe by having your AV program ignore that extension.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Liz James" <LizJames@discussions.microsoft.com> wrote in message
    news:ACC2D0FE-3366-4E5A-947E-ED8CE065BF5C@microsoft.com...
    > Spot on, Arvin. Many thanks.
    >
    > If someone uses the database on a corporate computer and has the same
    > problem, but is totally unable to turn off the virus monitoring because

    the
    > corporate network is so tightly controlled form head office, is there
    > anything else that can be done to speed up opening the first report each

    time?
    >
    > "Liz James" wrote:
    >
    > > Using OutputTo open reports in Excel. Office 2003, Access 2003.
    > >
    > > Opening report in Excel from Access is very slow for whichever report is
    > > opened first. Once the database is open and at least one report has been
    > > opened, subsequent reports open within a couple of seconds. That first

    report
    > > to open takes up to 2 minutes to open. I have tried opening Excel

    separately
    > > before opening the first report, but it makes no difference to the time
    > > taken.
    > >
    > > I have not found any questions relating to this on the discussion group.

    Do
    > > others experience this sluggishness? Is there something that I am

    missing
    > > here?
    > >
    > > The code I am using is below.
    > >
    > > DoCmd.OutputTo ObjectType:=acOutputQuery,

    ObjectName:="ReportCostsCondn3", _
    > > OutputFormat:=acFormatXLS, AutoStart:=True
    > >
     

Share This Page