Re: Best Method Of Storing Up To Date Website Imgaes
- From: "Arvin Meyer [MVP]" <a@xxxxx>
- Date: Thu, 14 Feb 2008 22:47:07 -0500
Storing images in a database will normally result in a bloated database that
will hold only a few hundred images (depending upon size) even if it held
thousand, storing a path is a much more efficient manner than storing a
second copy of the image. Use an image control to display it on the fly. I
have a sample database on my website that you can view (or import any part
of) for ideas on how to go about it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
"SEAN DI''''ANNO" <SEANDIANNO@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9B960387-398F-4A24-9A6F-9F60D3B619BB@xxxxxxxxxxxxxxxx
Good afternoon, I am very rusty at Access and did do lot of reseach
before
asking this question. I have a table that stores details of companies
called
companies. The Primary index of the table is an autonumber called
Company_Id
and stored within the table is information such as Web-Site First Mini
question is..is there a nice way of storing the website information in the
right format eg input mask. I want to store the web-page image of each
company on a form with different tabs e.g. Company Employees, General
Information etc. So far, I found a routine which creates a table with
links
to lots of images rather than store the image its self. All of the images
are
called for example 0001, 0002 etc (so that I can match them to the company
ID). Therefore in my created table called Artwork, there is a field with
the
path to the image and a field called CompanyID which is the number part of
the image name e.g. 1. On a tab on my form I inserted a subform with a
linked photo frame and the the source of the form is a query matching the
Company No on the main form (from my table Companies)to the company No in
the
table Artwork. It does work, and I have also created a hyperlink piece of
text so that if the user clicks on the website image it goes to the
website.
The problem I have is all of the images are of differnt sizes etc and
because they are stored images, it means that it it may not have a picture
of
the most up todate web site . What I really wanted to do was use the
Activex
Web Browser becuase then it is a real time link and the picture will
always
be upto date but the whole website picture is obviously too big for the
web
brower object. Therefore is there a way of either;
1 - Show the whole web-page but shrunk down as if the Web-browser was like
a
mini TV or
2 - When The user go a record or creates a new record with website
details,
the database will grab the image from the website and store that image
instead of the one stored. If this is possible could some one please take
the time to show me how.
.
- Prev by Date: Re: Outlook
- Next by Date: Re: Create form with access 2k3 color scheme with access 2k7?
- Previous by thread: Re: hello
- Next by thread: Re: Can I gather info on a PDA and 'dump' into Access?
- Index(es):
Relevant Pages
|
