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?