Best Method Of Storing Up To Date Website Imgaes

[SEAN DI''''ANNO]

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.

 

[Arvin Meyer [MVP]]

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.

 

[mrstuff]

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.