I have a complex report which has many subreports. When I preview this report, the active connections go down from 240 to about 30. Available connections are restored to 240 when the report is closed. However, with the report using so many connections, if the user tries to use certain functionality with the report still in preview, Access will show a "Cannot open anymore databases" error. Is there a way to close connections whilst a report is being previewed? Any suggestions are welcome.