Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2005
    Posts
    8

    Unanswered: Running Access reports

    When I run a report in access .. and then try to print it.. it gives me the error "sytem resource exceeded". The report prints 460 pages and I don't get this error until page 300 and onwards.

    Please let me know how I am my fix this.

    Thanks in advance!!

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Well let's see ... You're blowing out your printer driver ... You might want to look at trying to break up your report a bit or try prinnting select page ranges ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    You might try changing the properties for you printer to print directly to the printer. It sounds like you might be creating a spool file that is too large. Go to Printers edit the printer properties, then the Advanced tab.

  4. #4
    Join Date
    Nov 2005
    Posts
    8
    I print it out to acrobat as I need to pdf it. i tried compacting and repairing the database but it won't work. Please let me know if there is a possible way of solving it without breaking it up. Thanks again!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •