Using WinSCP sripting interface .NET wrapper in Microsoft Access will not close Access after use
Hi, I'm using WinSCP inside of Microsoft Access VBA now for more than a year and the FTP functionality works great. The problem I have is, after using, Access will not close anymore. I have to close it through the Task Manager.
Example Code:
Is there something I'm missing?
I open a session and I dispose the session.
What could cause Microsoft Access not to close after using that?
Thank you for your help.
Example Code:
Sub FTPdownload() Dim mySession As New Session Dim mySessionOptions As New SessionOptions Dim CSVFile As String Dim FTPPath As String Call connect(mySessionOptions) mySession.open mySessionOptions CSVFile = "order-latest.csv" FTPPath = "/store/order/output/order-latest" Call FTPdownload(mySession, FTPPath, CSVFile) mySession.Dispose Call doinport(CSVFile) End Sub
I open a session and I dispose the session.
What could cause Microsoft Access not to close after using that?
Thank you for your help.
