How do you put an image in Access (ver2000pro)

G

gildasd

HI,

I am trying to put an image colum in Access 2000 pro. So we know what we
refer to (we do events) and can CTRL+C to stick it in a presentation and so
forth...

Thanks to anyone that can help!

Could help you chaps in 3D max or Autocad...

G Dubois
 
R

RobertoM

Open the table in design view and declare a new column (say PHOTO) and define
it as an OLE Object. Add the control to you FORM in design view and then run
the form ensure you choose Stretch or clib in the field propeties. Right
click on the new PHOTO Control and then isert Object. Its browse until you
find the photo on you computer or networka nd then link to the image.

Advice, experience with different Photo images types i.e. .JPG, .GIF etc as
you may need to edit or check your file types extension in Windows Explorer
TOOLS option to ensure that the appropraite application is fired up when the
image is displayed.
RobertM
 
G

Guest

hi,
opinions vary on this issue. some say don't put pics in
the db just the file path to the pic to reduce file bloat.
others say the can reduce file bloat.
see this site. it has a downloadable sample db to show you
have to load jpgs without bloat. i haven't tried it out
myself.
http://www.lebans.com/loadsavejpeg.htm
regards
HDR
 
G

gildasd

hi all,

Thanks for the answers!

After consulting your messages and the tech pages of Microsoft, i'll be
opting for server side images and a bit of programming to get everything
nice and smooth.

I'm currently getting my boss to get a specialist to do it... We must create
a web consultable (HTML) access database (VBA code).

The original idea was to do it with Excell... But with only 85 of the
thousand or so lines tiped in, its allready surpassed 10megs...

Thanks again for the help.

G Dubois
 
A

Arvin Meyer

You may be interested in a free sample database which can be wholesale
imported into your application to handle pictures by opening outside files:

http://www.datastrat.com/Download/Picture2K.zip

You can reduce bloat by storing as a BLOB, but the database will still get
quite largw. I use an ActiveX control (DBPix) to handle images:

http://www.ammara.com

and you can find some great information at Larry Linson's website:

http://accdevel.tripod.com/imaging.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
S

SJ

Hi ,
just agreeing with Alvin.

don't put the images in the DB. create a text (255) if big enuf and store
the path/file name in there. Use code to display the image/file.

If you experiment with 1000 images , check the db size and check the file
sizes you'll be surprised.

I think it converts them to bitmaps.... not sure...
 
Top