Access 2007 seems to hang designing report - linked to ODBC Oracle

[geneking]

We use Access 2007 to do some ad-hoc reports from Oracle. We link using ODBC
and create a query with our criteria. If we try to create a report, Access
will appear to hang.

We have found that for some reason Access sends a SQL Select command through
ODBC to the database server but it does not include the criteria from the
view. If you have a very large table with thousands of rows and many columns,
it can take a long time for ODBC to retrieve the data. If you just run the
report, it uses the selection criteria and works great.

The problem also occurs if you are connected to a SQL Server database. It
was not a problem on Access 2003. I think there are some other instances
where this behavior is exhibited but I cannot duplicate the problem
consistently.

If I open the report in design view and right-click on any field in the
report to view the properties, it sends a query to the server without
criteria.

Is there some setting we can use to tell Access not to keep going to the
Server or at least to include the criteria when it does or perhaps just get
one row? The report is not using the data in the design view.

This behavior has caused a lot of problems for our users.