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

    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

    thanks

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    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
  •