I am having some issues with sFTP function in Access 97.

Anyone know what reference sFTP uses in Access? I can't seem to get it to work right in Access 97. Whenever I run execute an event that uses sFTP in access 97, it gives me a compile error saying the sub or function is not defined.

Specifically on this line is where it is blowing up on me:

sFTP ("C:\Documents and Settings\John.Patrick\Desktop\My Projects\Social Workers\PIP\PIPftp.txt")

It's probably something from a 3rd party library - it's certainly not native to Access. Take a look in your 'Tools > References' VBE menu option to see if there's an old link hanging around.

Hmmn, seems you are right. The previous programmer on this had it later on it the code on another application. Thanks for the help man!