Member Avatar for tgifgemini

Please, I need someone to show me the correct synatx - code to FTP a file (in an Access table) to a server.

The access table contains the following information:

Open
10.8.44.34
Username
Password
File path - sourcefile destinationfile
Quit.

I tried to run the code below and I get: a "Runtime error 438 - Object does not support this property of method"

InetFTP.Execute "ftp://mfuchk:58UA?UUW@10.8.37.44", "Put \\Livctrls03-08\Data1\APP\UNCLAIMW\UCCTest\Databases\DataFiles\Emp_Messages.txt  W.APPHRMS.UCCHKMSG"

I also trried the code below and got: a Runtime Error 13 - Type Mismatch.

InetFTP.ExecWB  "ftp://mfuchk:58UA?UUW@10.8.37.44", "Put \\Livctrls03-08\Data1\APP\UNCLAIMW\UCCTest\Databases\DataFiles\Emp_Messages.txt  W.APPHRMS.UCCHKMSG"

What am I doing wrong? Maybe wrong FTP syntax?

Thanks.
tgifgemini

Edited by mike_2000_17 because: Fixed formatting
  • 3 Contributors
  • 2 Replies
  • 299 Views
  • 3 Years Discussion Span
  • Latest Post Latest Post by evry1falls
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.