Instead of a subform, and HTML Page?

  • Thread starter Thread starter Lauren Quantrell
  • Start date Start date
L

Lauren Quantrell

I have a subform that has a recordsource that links numerous tables
including image fields. The result can contain one or many hundreds of
records. With a SQL Server backend on a slow WAN, the return can be
very slow (mainly because of the images.)
I was thinking maybe instead of having a subform, I'd create an HTML
page on the fly as the result of the recordset, then create a
hyperlink for each record to launch to an form to edit the record.
This way the graphics could be stored locally on each workstation.
Is there a way to so this: insert an HTML page into a form?
I have seem some questions on this and conflicting answers.
And if I can do it, is there an easy way to construct the HTML page on
the fly?
Or, maybe I just want to create the HTML page and view the results in
OE???
lq
 
This would be in my opinion a little backwards way of doing it. If you
want to go as far as browser based data access, might as well go into
scripting pages, or ADP. But it seems to me that all you need to do is
limit the dat ayour query returns and stick with Access. Don't return
the images; return hyperlinks to them, or better yet, return some record
identifiers that would let the user choose the record for editing. Then,
retrieve the images for that single record.

Pavel
 
Back
Top