By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,925 Members | 1,831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,925 IT Pros & Developers. It's quick & easy.

.Net Services: Available to MS Access 2003?

P: n/a
I need to get security attribution data - specifically information
about bonds.

The currently-suggested source is Bloomberg via an API that they make
available on their dedicated workstations.

Somebody in the client's org has already written a wrapper around the
BB API that runs on the BB PC all the time and presents itself to the
world as a "Service" which accepts a CUSIP and returns XML containing
data on the security in question.

My question: should I be trying to use that service from my MS Access
application or should I go after the API directly?

Using the service will save the client all the manhours I'd spend
picking the API apart. Also, I don't have a clue as to how to get to
that API on the BB PC from another PC.

OTOH, I'd still have to learn to use the service.

OTOOH, it will sound better that I'd be leveraging some of the client's
existing development efforts - and there's the service author's ego to

So I guess I'm biased in favor of using the service and parsing the
XML.... but is it possible within MS Access 2003?

Apr 24 '06 #1
Share this Question
Share on Google+
3 Replies

P: n/a
Yes, it is possible. I would even advise using this method. If any
consultant tried to bypass a customer's existing application services
to write his own, he is doing a disservice to the customer and
essentially stealing money.

You could get the documentation from the original developer to
determine the methodology for passing the data back and forth, but a
standard API methodolgy should work.
Chris Nebinger

Apr 24 '06 #2

P: n/a
Per ch************
Yes, it is possible.

What is possible?

Invoking a .NET service from MS Access 2003 and parsing the XML?
Apr 24 '06 #3

P: n/a
Yes, it is very possible. The method for doing so would be very close
to the method for a .NET application. I can't say exactly how it would
work, as each service is in and of itself unique. I have used Access
XP to connect to other services, however.

How does the service accept a CUSIP? Find that answer, and you'll have
your solution.

Apr 24 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.