Report without an active connection?

[benkarl]

For my current project, I need to report on data but I do not want to maintain a connection to the database while the report is open. When the report is opened, I just want it to open the tables, read the data and then close the table releasing the connection. It will then display data from memory.

The reason I want to do this is that a large number of users are expected for this application and I'm trying to keep the load on the backend database as low as possible. I know users will want to keep reports open and this will increase the load as long as they're open.

What I want is basically an ADO disconnected recordset, but those don't seem to work with reports.

Any ideas?

Thank you.

 

[dhookom]

I have created temporary mdb files for "reportable records" when a user opens an application. The user runs code that deletes and appends records as required for reports. This is generally very fast and doesn't require a constant connection to all back-end tables.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[benkarl]

I was afraid of that. I've done something similar before and I was hoping to avoid doing it again. I guess I won't be able to. Thanks.