Macro/VB FTP error

[thompsy]

Hi,

I'm hoping for some assistance please!

An ex-employee set up a database subscriber file to FTP from one server to another but hasn't documented how he set this up. Now that one of the servers has been upgraded, the FTP is failing.

I assume that the macro/script needs to be updated with the new server address within Access.

Can some please advise:
1) How I open this script/macro?
2) Is this the only amendment required?

The only info I can provide is that a SQL DTS package is triggered via a button within Access.

I don't have any experience in macros so layman terms would be great.

Thanks a lot
L

 

[gemma-the-husky]

might be a firewall issue, blocking the ftp access

 

[thompsy]

Hi Gemma, As far as I'm aware the firewall isn't an issue. A colleague advised that this issue arose before and that it was the Access macro at fault, though he doesn't know how it was resolved.

 

[DCrake]

Can you convert the macro to VB and post the results. This might also involve posting any functions that the macros call (if any).

You may want to anonomise certain aspects of it first though.

David

 

[thompsy]

Hi David,

As mentioned, I have very, very basic knowledge of macros. I can see the Convert Form's Macros to Visual Basic button but don't really know how to proceed from that point.

I'm assuming all that's needed is to update the server path within the macro.

I'd be grateful of further instructions?

Thanks

T

P.S.

I'm not sure if this'll help or not:

Private Sub Command11_Click()
On Error GoTo Err_Command11_Click
Dim stDocName As String
stDocName = "Update PeopleFind"
DoCmd.RunMacro stDocName
Exit_Command11_Click:
Exit Sub
Err_Command11_Click:
MsgBox Err.Description
Resume Exit_Command11_Click

End Sub

 

[thompsy]

A Bump for some assistance please!

 

[DCrake]

Go to Macros and highlight the Update people macro then go to tools > Macros > convert to Visual basic.

When converted it create a module of the converted macro design that and post whatever is in there.

David

 

[thompsy]

Hi David,

Thanks for the instructions. However, when I try to access items within Modules or Class Module, I get a Project Locked icon and within this it states " Project is unviewable"

How do I proceed from here. Would you like some screen shots?

Thanks for your help.

T

 

[thompsy]

Hi guys, it turns out I actually needed to update the server path within a hidden batch file.

Thanks for your help.