D
David Wilson
I have posted a version of this on Access/Security, but I am hoping that I
can get closer here.
The problem is as follos:
We have an MS Access Project that includes a VisualBasic module which when
invoked via script or macro sends an XML request via our SQL/IIS server to
another server to update data. In this case the connection is between our
server and the other server and the workstation only initiates the connection.
In Windows 2000 and Office XP if the user invokes the macro it runs as
expected and updates data from the remote server.
In Windows XP (SP2) and either Office XP or 2003 the attempt to run the
macro generates an error message which states that it "Failed to access
database server using https://blahblahblah". the error message claims to be
from MS Office, and offers no help or other info. No error shows up in the
log of either the client or the server, so I have no error log to fall back
on.
On this client if I paste the XML request URL into IE it WILL run and
perform the update, so I do not believe that it is related to either the
Internet or Trusted Sites security settings on the workstation. The
workstation CAN connect to our server via DNS and the user can view all
linked tables and such, including the Modules.
Is there some security setting in Access that would prevent it from invoking
a VisualBasic module to make an XML request from a remote server? Or is this
some interface issue between Office and Windows XP?
Any help at all?
Thanks!
David
can get closer here.
The problem is as follos:
We have an MS Access Project that includes a VisualBasic module which when
invoked via script or macro sends an XML request via our SQL/IIS server to
another server to update data. In this case the connection is between our
server and the other server and the workstation only initiates the connection.
In Windows 2000 and Office XP if the user invokes the macro it runs as
expected and updates data from the remote server.
In Windows XP (SP2) and either Office XP or 2003 the attempt to run the
macro generates an error message which states that it "Failed to access
database server using https://blahblahblah". the error message claims to be
from MS Office, and offers no help or other info. No error shows up in the
log of either the client or the server, so I have no error log to fall back
on.
On this client if I paste the XML request URL into IE it WILL run and
perform the update, so I do not believe that it is related to either the
Internet or Trusted Sites security settings on the workstation. The
workstation CAN connect to our server via DNS and the user can view all
linked tables and such, including the Modules.
Is there some security setting in Access that would prevent it from invoking
a VisualBasic module to make an XML request from a remote server? Or is this
some interface issue between Office and Windows XP?
Any help at all?
Thanks!
David