Using WinSCP sripting interface .NET wrapper in Microsoft Access will not close Access after use

Advertisement

soluter
Joined:
Posts:
2
Location:
USA, FL

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:
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
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.

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
41,276
Location:
Prague, Czechia

Re: Using WinSCP sripting interface .NET wrapper in Microsoft Access will not close Access after use

What does it exactly mean "will not close"? How does it manifest?

Reply with quote

Advertisement

You can post new topics in this forum