Set up Web Service thru ESB from existing Access Database Form

[Worsty]

We want to make a Call to Get Web Service, thru ESB, from existing
Access 2003 Database Form. These are the steps that we think we will
need to do to accomplish this.

We are inexperienced in this area and would like to know if anyone has
completed this type of set up before and could assist us in doing this.


 Invoke a web service from our Access 2003 Application
 Pass XML Document to the Web Service that contains a minimum of
these 3 fields:
o Submission_ID (Key for all SQL Views)
o QuoteLetter_Txn_Transaction_ID (26 character key used for accessing
data)
o QuoteLetter_Txn_Sequence_Number_ID (2 character key)


Thanks in advance for any help!

 

[Brendan Reynolds]

Here are some previous discussions on the subject of calling a web service
from Access ...

http://tinyurl.com/pyfkw

BTW, just out of curiosity, what is 'ESB'?

--
Brendan Reynolds
Access MVP

We want to make a Call to Get Web Service, thru ESB, from existing
Access 2003 Database Form. These are the steps that we think we will
need to do to accomplish this.

We are inexperienced in this area and would like to know if anyone has
completed this type of set up before and could assist us in doing this.


? Invoke a web service from our Access 2003 Application
? Pass XML Document to the Web Service that contains a minimum of
these 3 fields:
o Submission_ID (Key for all SQL Views)
o QuoteLetter_Txn_Transaction_ID (26 character key used for accessing
data)
o QuoteLetter_Txn_Sequence_Number_ID (2 character key)


Thanks in advance for any help!

 

[Worsty]

Brendan

ESP - Enterpise Service Bus.

I've taken a look at the links - actually looked at them before I
posted, and I've downloaded the Web Service toolkit, but don't know
where to go from there.

Any help?

 

[Brendan Reynolds]

I'm afraid I'm still no wiser as to what 'Enterprise Service Bus' might be,
so I don't know whether that makes a difference or not.

A number of the posts in those threads at the URL I posted are by me, so
I'm not sure what I can tell you that isn't already available to you there.
If you've downloaded (and installed) the Web Service Toolkit, then the next
step is to go into the VBA IDE and add a reference to your web service. The
toolkit adds a new command, 'Web Service References ...', to the Tools menu
in the VBA IDE.