Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    Edinburgh, Scotland
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    database hangs on print (Access 97)

    Hi, I have a fairly complex database, which includes 3 reports which are causing problems. If I open the database and print any one of these reports, the first report goes to the printer fine and causes no problems. If I then try to print or preview another, the database hangs the entire system (I can only break out by crashing out - ^alt/del doesn't work either). The data for these reports is fairly complex and goes through 4 individual queries to get to the point,. All of the queries are, individually, operating fine and with good speed. All the queries have the same base tables, with different criteria being selected into crosstab queries which then form the basis of a static report. Does anyone have any ideas what might be going wrong? I get the same problem using different p.c.s and different printers.......

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: database hangs on print (Access 97)

    Okay... This may be a realllllllllyyy silly response... but whenever that kind of thing happens for no apparent reason <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>,I start thinking possible corruption...
    Have you tried compacting/repairing or maybe importing everything into a new blank mdb?? ...Sometimes that works for me... It's just a thought...

    HTH

  3. #3
    Star Lounger
    Join Date
    Mar 2002
    Location
    Edinburgh, Scotland
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: database hangs on print (Access 97)

    Hi Trudy - yes thanks, have tried all that with no change.

    Thanks for idea though.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: database hangs on print (Access 97)

    It's possible you're overloading the processor and the execution never completes. Have you tried leaving it to see if it will *ever* complete? And what did you mean by ctl-alt-del not working?
    Charlotte

  5. #5
    Star Lounger
    Join Date
    Mar 2002
    Location
    Edinburgh, Scotland
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: database hangs on print (Access 97)

    Hi Charlotte, no it never completes - as I said, system just hangs (I have left it 15-20 minutes with no change). Control Alt Delete brings up the task manager to escape from a task/hung item, but trying to break out of Access in this way does not work either. Machine has to be "Crashed" out of by switching off altogether. Not sure what you mean by overloading the processor - I have tried on 2/3 different machines (none of which, mind you, are particularly high spec). Do you mean that the underlying query structure of the reports is just too complex for the spec of machine I'm working on?

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: database hangs on print (Access 97)

    You may have to post your DB without sensitive data etc, and let us take a look see.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: database hangs on print (Access 97)

    I had in mind something more like several hours. I had a 97 query a couple of jobs ago that processed something like 150,000 records and had to be run on a dual processor machine. Otherwise, it simply never completed.
    Charlotte

  8. #8
    Star Lounger
    Join Date
    Mar 2002
    Location
    Edinburgh, Scotland
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: database hangs on print (Access 97)

    Hi Pat, thanks - will have a look at doing this and try and post later in the week.

    Regards.

Posting Permissions

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