Report Freeze

[Todd Holt]

Hi, when I open a particular report using VB code,
instead of opening up in its own window, it opens up
(with the correct information) in the main Access window,
and then the entire application freezes.

The report has 3 subreports, and some code behind them,
but commenting out the code, and removing the subreports
doesn't seem to help.

The frusterating thing is that sometimes it opens
properly, and sometimes it doesn't, and I can't figure
out a way to successfully reproduce the error.

I am using 2 .mdb files. One is acting as the client,
and the other is acting as the server. The server file
is located on the network and is >100mb, which seems is
causing significant performance problems.

Has anyone else had a "report freeze" problem like this,
or have any ideas on how to fix it?

Thanks,

Todd

 

[Larry Linson]

Show us the code in re: the freeze.

For issues regarding performance and preventing corruption in
split/multiuser databases, see MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm. That's the best collection of links
and information I know about.

Larry Linson
Microsoft Access MVP

 

[Serge Olivier]

Is the Propety Modal or Popup set to True? If opening the repor in Popup,
then the code will stop and wait for the report to close before to continue.

HTH
Serge