<div>
Is the application closed every night. &nbsp;shutting down the ADP will disconnect if from SQL Server. &nbsp;May I ask why you want to do this via code?<br />
<br />
Mike<br />

</div>


Is the application closed every night.  shutting down the ADP will disconnect if from SQL Server.  May I ask why you want to do this via code?

Mike


<div>
No we don't want to ever shut the application down. &nbsp;We shutdown our SQL servers each night prior to backing them up which causes our utility to error out so we need to shut it down at 11pm and re-connect at 2am. &nbsp;And I can't get anyone to volunteer to come in! :)
</div>


No we don't want to ever shut the application down.  We shutdown our SQL servers each night prior to backing them up which causes our utility to error out so we need to shut it down at 11pm and re-connect at 2am.  And I can't get anyone to volunteer to come in! :)

<div>
Thanks did some digging on google for CurrentProject.CloseConnec<wbr />tion and found some sample code!
</div>


Thanks did some digging on google for CurrentProject.CloseConnection and found some sample code!

<div>
<div class="content wysiwyg-content">
Hi there,<br />
<br />
We've written a utility (ADP - SQL backend / Access ADP on the front) that we need to disconnect from the SQL server via code each night and then reconnect early in the morning. &nbsp;Does anyone know how to do this via code? &nbsp;Thanks!<br />

</div>
</div>


Hi there,

We've written a utility (ADP - SQL backend / Access ADP on the front) that we need to disconnect from the SQL server via code each night and then reconnect early in the morning.  Does anyone know how to do this via code?  Thanks!


ADP disconnect / reconnect using code

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.