11-30-2007, 07:21 AM
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.
11-30-2007, 07:34 AM
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")
11-30-2007, 08:23 AM
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.
11-30-2007, 09:15 AM
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!