Hi All,



I have a report that I saved as a data access page. The purpose is to allow anyone to run the report and use the data. The report doesn't need to allow for data entry or anything else. The trouble is when someone runs the report, their connection to the DB remains open until they close out their browser window. What i'd like to have happen is for the page to connect to the db, run the report, then close the connection. If the user refreshes, it should start that all over again.

Any ideas on what I should add to the code in the DAP to close my connection?

Thanks!