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 )

--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/

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.

On Sun, 28 Oct 2007 17:33:06 -0400, "Fred Boer" <(E-Mail Removed)>
wrote:

>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 )

Dear Michael:

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

--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/

"Michael Gramelspacher" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.
>
> On Sun, 28 Oct 2007 17:33:06 -0400, "Fred Boer"
> <(E-Mail Removed)>
> wrote:
>
>>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 )

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.

On Mon, 29 Oct 2007 08:41:46 -0400, "Fred Boer" <(E-Mail Removed)>
wrote:

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

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 - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/

"Michael Gramelspacher" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
> On Mon, 29 Oct 2007 08:41:46 -0400, "Fred Boer"
> <(E-Mail Removed)>
> wrote:
>
>>I will look into this as soon as possible though it may not be until later
>>this afternoon.

"Michael Gramelspacher" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
> On Mon, 29 Oct 2007 08:41:46 -0400, "Fred Boer"
> <(E-Mail Removed)>
> wrote:
>
>>I will look into this as soon as possible though it may not be until later
>>this afternoon.

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

"Michael Gramelspacher" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
> On Mon, 29 Oct 2007 08:41:46 -0400, "Fred Boer"
> <(E-Mail Removed)>
> wrote:
>
>>I will look into this as soon as possible though it may not be until later
>>this afternoon.