Trying To Run DTS Package From Microsoft Access

Hello,

I am trying to execute a DTS package that updates a SQL database from a Microsoft Access form using a command button. The computer I created the access app on is the same computer that hosts the SQL Server and when I run it form there it works fine. However when I run it from another machine across the network the package does not work and I am having login failure problems with other users even though I have added them to the database. I need to use Windows Authentication for this, here is the code I am using in VB on the MSFT Access form. Do I need to specify username & password if specifying a trusted connection?

Private Sub Command0_Click()

Dim dtsp As New DTS.Package
dtsp.LoadFromSQLServer "MYSERVER", "SERVER_USER_NAME", _
"USER_NAME_PWD",DTSSQLStgFlag_UseTrustedConnection, "", _
"", "", "TGImport"
dtsp.Execute

End Sub

Thanks Much!!