MS Access 2003 Bound Object Frame - Not showing multiple pages

[Guest]

I am linking MS Access 2003 to SQL Server 2000. I am trying to display a one
to many set of images to a single set of data. In SQL Server I have the
objects set as data type Image. In MS Access I have a sub-report with one
control on it, Bound Object Frame.

This method of report generation is working as long as each Image file is
one page. When multiple pages are needed, only the first image page
displays. For example, one of my Image formats is a PDF file with 3 pages.
Page 1 displays fine, but 2 and 3 never show up.

Regards

 

[Guest]

Yes, that is what you get.

Sorry.

(david)

 

[Guest]

Is there a way to fix it?

I am open to other scenario's, not locked into SQL Server.

 

[Guest]

Reports only show the first page of bound objects.

PDF pages are displayed by your PDF viewer. To get
more pages, you have to instruct your PDF viewer to display
the pages, and you have to instruct the report to show
multiple copies of your PDF viewer object.

The graph object can do this: you can pass different data
to the graph object, and get it to display a different graph
on every page.

If you can find a PDF viewer object that can be programmed
to display one particular page from a pdf file, you could probably
place it on a report and program the report to have multiple
pages, so that you could program the PDF Viewer object
separately for every page.

(david)