Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007

    Unanswered: Access 97 Freezes whwen veiwing a report

    We have an access 97 database. and every few weeks a run a report that is 179 pages.

    however access freezes on 2 pages of the report. when trying to view page 137 and 138 access just freezes up and i have close access via the task manager.

    could this be the report that is corrupt and i have to re generate the report from the query

    or is the data that is trying to be displayed on those 2 pages corrupt???

    im not much of a db and havent used access since uni lol

    any help would be great


  2. #2
    Join Date
    Dec 2004
    Madison, WI
    Do you have any dlookup commands in any of the fields? Are the key fields you're sorting on indexed? Are there any If/then... statements which could be delayed or not computing the data on these pages? Do any of the field values of the records in these 2 pages look odd or wierd compared to the other data? Is there any data which is causing a lot of page reformatting (ie. growing of fields) on these pages? Try changing the recordsource query properties of the report (recordset type property) to a snapshot.

    You can also try creating another copy of the report and set it so the query just queries the specific page 137-138 data and see if that is taking a while or freezes.
    Last edited by pkstormy; 10-24-07 at 10:39.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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