Blank report during print preview

[Hosacans]

Hi all,

everyday I run a stats report from an access database. And every once in a while (which often occurs in one of those busiest of days), Access will give blank reports when i go into the print/preview mode.

usually, i would import raw data (text files). start a macro that runs the queries... and then open the report with print preview... and just print the report to Adobe.

but today... the print preview come up with blank pages. I know for sure the database is running correctly. all the tables were properly populated. and all import files are correct. even the sub reports embedded to the main report shows up with data, if i open then individually.

whenever this happens in the past, i would have to restart my computer and rerun the database... then it would work correctly, but that's very time comsuming...

so i am just wondering what would be some causes to this problem. i speculate that it might have something to do with the computer's memory, but i am no where qualify to make that judgement. this is a very irritating problem, and i cant seem to figure out why...

if anyone can help... it's much appreciated.

Thanks
Hosacans

 

[Melagan]

My first suggestion would be to backup then reindex your database before running your print preview.

~Melagan
______
"It's never too late to become what you might have been.

 

[Hosacans]

Hi Melagan,

What do you mean by reindex?

Thanks
Hosacans