ole objects photos

S

slvrnmph

I'm trying to insert pictures into a an access 2003 database as ole objects,
and keep getting an ole database error. I've seen solutions for this using
microsoft photo editor, which I don't have. Is there a way to correct this
problem without photo editor? Or another way to insert pictures other than as
an ole object?
 
R

Roger Carlson

Actually, the best way is to NOT insert pictures into the database itself.
It is better to leave the picture in the file system and just store the path
the the picture in the database. Then you can programmatically load the
picture into a form or report at runtime.

On my website (www.rogersaccesslibrary.com) is a small sample database
called "Pictures.mdb" which illustrates how.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
J

Joe Leon

Hi Roger... I looked at your application and it very good but here is my
additional problem..

I have pictures in several directories be cause they are categorized by
subject. What I would like to accomplish is to place the name of the file,
which happens to be in *.bmp form, in the column as you suggested but start
at a top directory and search its subdirectories for the picture. Is this
possible?

Thanks!
 
J

Joe Leon

Thanks Arvin!

It does what I need... now I can look at the code and figure out how to
incorporate something similar into my application!

Thanks!!!
Joe...
 
J

Joe Leon

This is a question for Arvin regarding Picture2k.

In the filepath column, is there a limit to the number of characters in the
file path? Is there a way to make the limit greater? The filepath below is
what is generated from when finding the picture. I could map a drive to start
at TekScope_Captures but then someone else might not be able to see the image
when I place the database program in a different directory.

FilePath
\\Fl4\hwdata\HWEng\QuickSilver\SCM\Doc\Verification\TekScope_Captures\P0_P27_RXCLK\Diskette 0011 0012 & 0013\Test21 P0-P9_RXCLK 25MHZ\
 
A

Arvin Meyer

You can make the field length up to 255 characters with that datatype. If
that's not long enough, change the datatype to memo and you can make a path
longer than any computer file system can resolve. One concern though is
speed. If your image is tucked down into a deep file tree, you may find
performance to be poor.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Joe Leon said:
This is a question for Arvin regarding Picture2k.

In the filepath column, is there a limit to the number of characters in the
file path? Is there a way to make the limit greater? The filepath below is
what is generated from when finding the picture. I could map a drive to start
at TekScope_Captures but then someone else might not be able to see the image
when I place the database program in a different directory.

FilePath
Click to expand...
\\Fl4\hwdata\HWEng\QuickSilver\SCM\Doc\Verification\TekScope_Captures\P0_P27
_RXCLK\Diskette 0011 0012 & 0013\Test21 P0-P9_RXCLK 25MHZ\
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert multiple objects at once ? 3
Adding a photo to a record 7
OLE Object Data Type Question 8
"OLE server not registered" 1
Linked OLE Object 3
Insert new photo album - photos are in reverse order 0
Access, OLE and Kodak EasyShare 1
Photo object in Access 2000 has lost the plot in 2007 0

Top