I maintain a mature Access 97 application, divided into front and back ends. A report is based on Query2, which is in turn based on Query1. Query 1 is the main data table with outer joins to about 2 dozen lookup tables. Query 2 applies selection criteria from a user form to generate the resultset used by the report.
Now I need to create a new report, which will basically be a specialized version of the existing one, so I have to copy Query2 and edit the copy appropriately. Whenever I try to open Query2, or a copy of it, in Design View, Access locks up with a perpetual hourglass. Yet the report runs fine, and I can open Query1 in Design View, and both queries in Datasheet View, without any problem. I've already tried creating a new database and importing all the objects from the old one into it, but this problem persists.
Any ideas?
Now I need to create a new report, which will basically be a specialized version of the existing one, so I have to copy Query2 and edit the copy appropriately. Whenever I try to open Query2, or a copy of it, in Design View, Access locks up with a perpetual hourglass. Yet the report runs fine, and I can open Query1 in Design View, and both queries in Datasheet View, without any problem. I've already tried creating a new database and importing all the objects from the old one into it, but this problem persists.
Any ideas?
