Demos available: using Z39.50, SRU/SRW, XML and Amazon Web Services from Within Microsoft Access

[Fred Boer]

Hello:

For some time I have been interested in ways of retrieving cataloguing
information from the Internet for use in my small libary application. (...my
apologies to regulars here who may be heartily sick of hearing about it!
<g>).

Although I am *not* expert in these things, I have just posted several
demonstration databases that show the following: the use of Z39.50 to
retrieve MARC records from libraries such as the Library of Congress; the
use of SRW/SRU to do this without a Z39.50 client; and the use of web
services to download information from Amazon.com. Data is downloaded into a
Microsoft Access form. It is retrieved as XML and parsed with XML methods.
There are demos in Access 2000 and Access 2007 formats.

For those with only limited interest (and this includes most of my family,
friends and colleagues <g>) - there are some screen shots that provide a
quick visual demonstration.

Demos are available at the web site in my signature (and specifically at:
http://www3.sympatico.ca/lornarourke/fred2.html )

 

[Michael Gramelspacher]

I gave it a try, but MARCAmazonSRU.mdb crashes Access after selecting an ISBN in
the combobox, and wants to send an error report to Microsoft.

I numbered the code lines and put a breakpoint on line 246. Then when I
continue, it runs without crashing. I then go back to Access and the form is
not visible, so I double-click the name and it opens with the data is there as
expected.

I am using Access 2003 and Windows XP.

 

[Fred Boer]

Dear Michael:

I will look into this as soon as possible though it may not be until later
this afternoon.

 

[Michael Gramelspacher]

Fred, I created a new database and imported all objects into it, decompiled,
compacted, and recompiled, and now it works. So, please disregard my previous
message.

 

[Fred Boer]

That's great Michael, but I will be sure to check all of the files as soon
as I can in any case!

 

[Fred Boer]

Fred, I created a new database and imported all objects into it,
decompiled,
compacted, and recompiled, and now it works. So, please disregard my
previous
message.

 

[Fred Boer]

Dear Michael:

I have experienced an issue with the files as well, which I will be posting
about. I have made some changes which I hope improves the reliability of the
files, but I still have an outstanding problem which I hope to clear up
soon.

Thanks!
Fred