Data designer populates slow with many pages

I am trying to create some reports using vb6 and data designer. It loads successfully, but it takes about 45-90 seconds for the report form to load and become active, just a white screen and an hourglass. I am printing about 75-100 pages of data from an access 97 database.

When it does finally load, it works well. Anyone know what can be done so that the report will populate quicker? Would converting the database to Access 2000 data structure make it populate any quicker?

Thanks for any help.

PS. anyone know how to easily add a page number to each page?

with regards to your p.s.

insert an rptlabel on your data report's page header or footer section then set it's caption to %p

if you want to display the page totals just set caption to %P

Thanks for the page number tip.... I will try that.

Upgrading to Access 2000 improved performance, seems that Jet 4.0 is slightly more efficent.

Another question:

I want to print reports that have two columns in landscape mode instead of portrait.

How can you format data designer to print in landscape.. anyone?


:o