Visual Basic Code in Microsoft Access ADP

We are using Access ADP's to serve reports to our end users. We recently moved to SQL Server 2008 and have noticed that when closing our Access ADP's they often hang. Further investigation showed multiple write accoss the network to close the ADP when hitting the Exit button. Below is the code that we use to close the ADP. I was wondering if there is a better way to close the Access ADP. Since we do not write data back to the database on close I simply wish to kill the Access Session.

' Note that you can close things and set to nothing in the main part of the procedure
' or simply wait for the exit. But if you do this in the main part of the code,
' you still need to do it within the exit because an error at any point may leave things
' open
rs1.close
Set rst = Nothing

' Do some more stuff

MyProcedure_Exit:
' Cleanup

On Error Resume Next

' Need to close the recordset and set to nothing the object variable.
rst.close
Set rst = Nothing

' Note here, there is no close because you didn't open the connection, but rather
' used the projects connection
Set cn = nothing

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…

Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.

The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability.
Flipping Coins in Excel: Enter =RAND() into cell A2:
Recalculate the random variable…

The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…