Updating website using ftp command
In the searchable online directory, an asp file interfaces with an Access database.The data in the online database search is updated though an internal custom Access application.
This action successfully completes, and the data connection is closed.I created a function to export a query to an mdb file and then FTP it to the web server.A user simply clicks a command button anytime they want to update the website.The result will be either 0 or 1, depending on if the flag is set or not.These defines are predefined OR-combined mode flags.Path & "\" str File Name = "Test.mdb" 'Name of file to upload 'FTP Server Settings ftp Server = "Your FTP Server" str User Name = "Your FTP User Name" str Password = "Your FTP Password" 'Create text file containing FTP commands p File = Free File Open str Path & "FTP_cmd.txt" For Output As p File Print #p File, "user" Print #p File, str User Name Print #p File, str Password Print #p File, "Put " & str File Name 'Use the Put command to upload, use the Get command to download.
'Print #p File, "Get " & "Your File Name" Print #p File, "quit" Close p File 'Create batch file to execute FTP p File = Free File Open str Path & "FTP_Run.bat" For Output As p File Print #p File, "ftp -n -s:" & "FTP_" & ftp Server Print #p File, "Pause" Close p File 'Execute FTP command Shell str Path & "FTP_Run.bat", 1 Err_Trap_Exit: Exit Function Err_Trap: Msg Box Err.
Function FTP_Data() '========================================================================= 'FTP from Microsoft Access 'by Matthew V Carmichael 'Craetes FTP Batch File, FTP command file (txt) 'Default directory location of files to upload/download is 'the same location as the mdb file that contains this module.
'=========================================================================' On Error Go To Err_Trap Dim p File As Long Dim str Path As String Dim str File Name As String Dim ftp Server As String Dim str User Name As String Dim str Password As String 'Path and Name of file to FTP str Path = Current Project.
For troubleshooting Cute FTP connection problems, also refer to Troubleshooting Cute FTP Connection Problems.
The table below is provided so that you have some idea whether you can solve the issue on your own (e.g., code 331=you need to provide a password) or you need to call your ISP for assistance (e.g., code 426=you are unable to connect to the remote server). NOTE: The information below is only offered as a courtesy to assist you in telling your Internet Service Provider what the error is so that they can help solve your issue.
Try logging back in; contact your hosting provider to check if you need to increase your hosting account; try disabling the firewall on your PC to see if that solves the problem.