How to change a path in Access/VB?

[brainst0rm]

Hi there. I have a form with some functions: in particular I'd like to change what a button do: when I click it, the form calls this:

Runtime erroe 3304
S:\Commercial\2006Businessplan.xls is not a valid path
etc etc etc

Basically this file is now hosted in another server, but I don't know how to change this path. Here the onClick propriety:

Private Sub productreportattrqry_Click()

Dim stDocName As String

    stDocName = "Weekly Product Sales Analysis Attributes"
    DoCmd.OpenQuery stDocName, acNormal, acEdit


End Sub

Thanks. Diego.

 

[kidrobot]

Is that all of the code for the button?

 

[brainst0rm]

Is that all of the code for the button?

As far as I know, yes. How can I know if it's actually only this?

Thanks for your help. Diego.