LoadSaveJpeg

[Guest]

I downloaded this file from Stephen Lebans site.
http://www.lebans.com/loadsavejpeg.htm

Can someone explain how to get this function into an existing database?
I am trying to get the JPG photos of cattle external to the database, to keep the size of the database below 1GB.

Related problem:
I also put the "ijl15.dll" into my System folder, as instructed in Stephen Lebans file. I don't know if this is causing a new issue. But now, in other old databases when I try to insert a linked picture it only inserts an Icon link to the picture. In the table it says "Package" instead of "Microsoft 3.0 Photo". (It always worked before, and other records still have their picture).
Incidentally, I also put the dll file in the W32system folder.

My level of expertise is pretty basic in database building. I am using Access97(SR2); I have the help file, a book by Susan Harkins, and a few other basic references.

I appreciate your help!

Thanks
Ron

 

[Stephen Lebans]

Ron I think you should forget about my solution and just do things the
easy way. Leave your photos in a folder. My solution is for those people
that need to keep their photos wihtin the MDB due to distribution or
security concerns.

The OLE Server issues you are having have absolutely nothing to do with
copying the Intel DLL to your system folder(s).

Simply link your photos at runtime. Larry has a great tutorial at his
site here:
http://accdevel.tripod.com/

A couple of good articles here:
http://www.mvps.org/access/forms/frm0030.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

I downloaded this file from Stephen Lebans site.
http://www.lebans.com/loadsavejpeg.htm

Can someone explain how to get this function into an existing database?
I am trying to get the JPG photos of cattle external to the database,

to keep the size of the database below 1GB.

Related problem:
I also put the "ijl15.dll" into my System folder, as instructed in

Stephen Lebans file. I don't know if this is causing a new issue. But
now, in other old databases when I try to insert a linked picture it
only inserts an Icon link to the picture. In the table it says
"Package" instead of "Microsoft 3.0 Photo". (It always worked before,
and other records still have their picture).

Incidentally, I also put the dll file in the W32system folder.

My level of expertise is pretty basic in database building. I am using

Access97(SR2); I have the help file, a book by Susan Harkins, and a few
other basic references.

 

[Guest]

2-2-04 Could not get this sent

Stephen,
I wish I could do it the 'easy way' - that is the way I designed the database (linked photos from another folder) and had been using it for years. However, now the database has 'reached maximum size' and I am looking for some way to get the pictures out of the data base.

Also, could you please comment on my second related issue:
I also put the "ijl15.dll" into my System folder, as instructed in Stephen Lebans file. I don't know if this is causing a new issue. But now, in other old databases when I try to insert a linked picture it only inserts an Icon link to the picture. In the table it says "Package" instead of "Microsoft 3.0 Photo". (It always worked before, and other records still have their picture).
Incidentally, I also put the dll file in the W32system folder.

My level of expertise is pretty basic in database building. I am using Access97(SR2); I have the help file, a book by Susan Harkins, and a few other basic references.

I appreciate your help!

Thanks
Ron


----- Stephen Lebans wrote: -----

Ron I think you should forget about my solution and just do things the
easy way. Leave your photos in a folder. My solution is for those people
that need to keep their photos wihtin the MDB due to distribution or
security concerns.

The OLE Server issues you are having have absolutely nothing to do with
copying the Intel DLL to your system folder(s).

Simply link your photos at runtime. Larry has a great tutorial at his
site here:
http://accdevel.tripod.com/

A couple of good articles here:
http://www.mvps.org/access/forms/frm0030.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

I downloaded this file from Stephen Lebans site.
http://www.lebans.com/loadsavejpeg.htm database?
I am trying to get the JPG photos of cattle external to the database,

to keep the size of the database below 1GB.

I also put the "ijl15.dll" into my System folder, as instructed in

Stephen Lebans file. I don't know if this is causing a new issue. But
now, in other old databases when I try to insert a linked picture it
only inserts an Icon link to the picture. In the table it says
"Package" instead of "Microsoft 3.0 Photo". (It always worked before,
and other records still have their picture).

Incidentally, I also put the dll file in the W32system folder.

Access97(SR2); I have the help file, a book by Susan Harkins, and a few
other basic references.

 

[Stephen Lebans]

Why do you have to get the pictures out of the MDB if they were only
linked to begin with? Where are the original photos? If you simply have
your terminology mixed up and the photos were actually embedded then you
can get them out with this tool:
http://www.lebans.com/oletodisk.htm
Unfortunately the latest release is A2K or higher only. Hopefully you
have an A2K install that you can access to run the sample MDB from. It
does not matter that the photos are in an A97 MDB. If you cannot get at
an A2K install than you can use the older A97 solution on my site.

As I stated previously there is absolutely no way that copying the
Intell DLL to your System folder would in any way whatsoever cause
problems with your registered Image OLE Server program...period. THere
is something wrong with your install of MS Photo Editor. You probably
have lately installed a program that has become the registered viewer
for whatever Image type you are now trying to insert into your MDB. A
search on Google will yield lots of hits explaining this issue in
detail.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

2-2-04 Could not get this sent

Stephen,
I wish I could do it the 'easy way' - that is the way I designed the

database (linked photos from another folder) and had been using it for
years. However, now the database has 'reached maximum size' and I am
looking for some way to get the pictures out of the data base.

Also, could you please comment on my second related issue:
I also put the "ijl15.dll" into my System folder, as instructed in

Stephen Lebans file. I don't know if this is causing a new issue. But
now, in other old databases when I try to insert a linked picture it
only inserts an Icon link to the picture. In the table it says
"Package" instead of "Microsoft 3.0 Photo". (It always worked before,
and other records still have their picture).

Incidentally, I also put the dll file in the W32system folder.

My level of expertise is pretty basic in database building. I am using

Access97(SR2); I have the help file, a book by Susan Harkins, and a few
other basic references.

 

[Guest]

Stephan,

My terminology is correct = LINKED
It surprised me too.
Here is what I have learned:
--------------
......, as well as 'linking' to the original file, a 'Preview' image is stored in the database. Since this image is uncompressed it can be up to 100 times the size of the original image file (or more), hence the problem you are seeing.
---------------

So, I don't need an extraction tool. But, I do need a way to get the photos "Out of the Database".

So far I have suceeded in adding a text field to the database that indentifies the 'path' to the individual photo related to the file (the cow that is record #1, 2, etc.) However, It is very cumbersome to type the path in for each record.
Will Your LoadSaveJpeg tool work as a "look-up" to find the picture and enter the path in the field of the record?

Thanks for your help.
Ron


----- Stephen Lebans wrote: -----

Why do you have to get the pictures out of the MDB if they were only
linked to begin with? Where are the original photos? If you simply have
your terminology mixed up and the photos were actually embedded then you
can get them out with this tool:
http://www.lebans.com/oletodisk.htm
Unfortunately the latest release is A2K or higher only. Hopefully you
have an A2K install that you can access to run the sample MDB from. It
does not matter that the photos are in an A97 MDB. If you cannot get at
an A2K install than you can use the older A97 solution on my site.

As I stated previously there is absolutely no way that copying the
Intell DLL to your System folder would in any way whatsoever cause
problems with your registered Image OLE Server program...period. THere
is something wrong with your install of MS Photo Editor. You probably
have lately installed a program that has become the registered viewer
for whatever Image type you are now trying to insert into your MDB. A
search on Google will yield lots of hits explaining this issue in
detail.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

2-2-04 Could not get this sent
I wish I could do it the 'easy way' - that is the way I designed the

database (linked photos from another folder) and had been using it for
years. However, now the database has 'reached maximum size' and I am
looking for some way to get the pictures out of the data base.

I also put the "ijl15.dll" into my System folder, as instructed in

Stephen Lebans file. I don't know if this is causing a new issue. But
now, in other old databases when I try to insert a linked picture it
only inserts an Icon link to the picture. In the table it says
"Package" instead of "Microsoft 3.0 Photo". (It always worked before,
and other records still have their picture).

Incidentally, I also put the dll file in the W32system folder.

Access97(SR2); I have the help file, a book by Susan Harkins, and a few
other basic references.

 

[Stephen Lebans]

*WARNING - ALWAYS WORK ON A COPY OF YOUR MDB*
Just delete the contents of the OLE field. In Design view for the
relevant table simply delete the OLE field.

Arvin has a tool on his site for scanning a folder and creating the lins
to the individual photos.
http://www.datastrat.com/DataStrat2.html
Select the proper version of the PictureManager MDB.

Good Luck.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

Stephan,

My terminology is correct = LINKED
It surprised me too.
Here is what I have learned:

stored in the database. Since this image is uncompressed it can be up
to 100 times the size of the original image file (or more), hence the
problem you are seeing.

---------------

So, I don't need an extraction tool. But, I do need a way to get the photos "Out of the Database".

So far I have suceeded in adding a text field to the database that

indentifies the 'path' to the individual photo related to the file (the
cow that is record #1, 2, etc.) However, It is very cumbersome to type
the path in for each record.

Will Your LoadSaveJpeg tool work as a "look-up" to find the picture

and enter the path in the field of the record?

 

[Guest]

Stephan
Thanks for your help and patience
Okay -- I believe I am getting close
First to clarify: I did not mean "get the pictures OUT of the database" I should have said: "Design a database that can retrieve and show pictures that are not in the database

I have the database now working with a text field in a table, that indentifies the 'path' to the individual photo related to the file (the cow that is record #1, 2, etc.)
However, It is very cumbersome to type the path in for each record

Example: C:\Documents and Settings\Ron\My Documents\RRE, LLC\CattleDB\LhornPhotos\01Lhorns.jp

What I am trying to do is design a 'command' button (or whatever) to browse the directory and folder that the cattle pictures are located in. So that I can add new photos without typing the entire path

Can you recommend some method of doing this

Sincere Thanks
Ro

 

[Stephen Lebans]

THe last link I pointed you to at Arvin's site will take all of the
images in a folder and insert their filenames in an MDB.
Remember you really should not store the full path rather only the
filename. Simply set the path at runtime prior to loading the photos
into an Image control.
For code you can place behind a ComandButon to call the standard Windows
File Dialog see:
http://www.mvps.org/access/api/api0001.htm


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

Stephan,
Thanks for your help and patience.
Okay -- I believe I am getting close.
First to clarify: I did not mean "get the pictures OUT of the

database" I should have said: "Design a database that can retrieve and
show pictures that are not in the database"

I have the database now working with a text field in a table, that

indentifies the 'path' to the individual photo related to the file (the
cow that is record #1, 2, etc.)

However, It is very cumbersome to type the path in for each record.

Example: C:\Documents and Settings\Ron\My Documents\RRE, LLC\CattleDB\LhornPhotos\01Lhorns.jpg

What I am trying to do is design a 'command' button (or whatever) to

browse the directory and folder that the cattle pictures are located in.
So that I can add new photos without typing the entire path.

 

[Guest]

Stephan
Thanks again
I went to this site you recommended: http://www.mvps.org/access/api/api0001.ht

I tried just copying the code to the 'Build Event' window --
I copied from
'***************** Code Start *************
T
'************** Code End ****************

However, when I use the 'DEBUG' feature before saving it comes up with many errors, like "Only comments may appear after End Sub, End Funtion, or End Property." This shold up with a highlight on
Declare Function aht_apiGetOpenFileName Lib "comdlg32.dll"
Alias "GetOpenFileNameA" (OFN As tagOPENFILENAME) As Boolea

Can you give me a clue how to install this

Arvin's site doesn't really seem to fit my application, since I have a need to continue to add photos into the database

----- Stephen Lebans wrote: ----

THe last link I pointed you to at Arvin's site will take all of th
images in a folder and insert their filenames in an MDB
Remember you really should not store the full path rather only th
filename. Simply set the path at runtime prior to loading the photo
into an Image control
For code you can place behind a ComandButon to call the standard Window
File Dialog see
http://www.mvps.org/access/api/api0001.ht


-

HT
Stephen Leban
http://www.lebans.co
Access Code, Tips and Trick
Please respond only to the newsgroups so everyone can benefit

Stephan
Thanks for your help and patience
Okay -- I believe I am getting close
First to clarify: I did not mean "get the pictures OUT of th

database" I should have said: "Design a database that can retrieve an
show pictures that are not in the databaseindentifies the 'path' to the individual photo related to the file (th
cow that is record #1, 2, etc.

However, It is very cumbersome to type the path in for each record

browse the directory and folder that the cattle pictures are located in
So that I can add new photos without typing the entire path

 

[Guest]

Stephan

You said this in your last reply
"Remember you really should not store the full path rather only the filename. Simply set the path at runtime prior to loading the photos into an Image control.

How and where do I 'set the path at runtime'
--------------------
Please also see my other earlier reply / question
Hopefully, this will wrap it u

Thanks again
Ro

 

[Stephen Lebans]

You have to place the code within a standard Code module not in the clas
module behind your form.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

Stephan,
Thanks again.
I went to this site you recommended: http://www.mvps.org/access/api/api0001.htm

I tried just copying the code to the 'Build Event' window --
I copied from:
'***************** Code Start **************
TO
'************** Code End *****************

However, when I use the 'DEBUG' feature before saving it comes up with

many errors, like "Only comments may appear after End Sub, End Funtion,
or End Property." This shold up with a highlight on:

Declare Function aht_apiGetOpenFileName Lib "comdlg32.dll" _
Alias "GetOpenFileNameA" (OFN As tagOPENFILENAME) As Boolean

Can you give me a clue how to install this?


Arvin's site doesn't really seem to fit my application, since I have a

need to continue to add photos into the database.