Import jpg-files ?!?

[Tom]

Hi

I have to import 1000 jpg-pictures into an access-database. Are there any
sample scripts available?

Many thanks in advance.

Tom

 

[Dirk Goldgar]

Hi

I have to import 1000 jpg-pictures into an access-database. Are there
any sample scripts available?

Most people will tell you that it's not a good idea to import your
pictures into the database, if you can avoid it. Unless you take some
rather complicated and unusual steps, storing pictures in a database
leads to enormous bloat, because Access *always* saves the image in
bit-map format *along with* the original JPEG image data. It's simplest
to keep the image files external to Access, usually in a folder
designated for the purpose, and save only the name of the image file, or
the full path to the file, in the database. Then the image can be
displayed on demand by setting the Picture property of an unbound Image
control to the path to the file.

If you insist on storing the image data inside the Access database, have
a look at Larry Linson's image-handling examples at:

http://accdevel.tripod.com/imaging.htm

Among others, he shows a technique for storing an image file as a BLOB
in the database and extracting it as needed, thereby avoiding bloat.

 

[Larry Linson]

If you insist on storing the image data
inside the Access database, have a
look at Larry Linson's image-handling
examples at:

http://accdevel.tripod.com/imaging.htm

Among others, he shows a technique for
storing an image file as a BLOB in the
database and extracting it as needed,
thereby avoiding bloat.

Thanks for the kind words, Dirk. It doesn't avoid as much bloat as using
external image files, but there are times when it is a useful alternative.

Larry

 

[Tom]

Thank you very much for the answer!

Tom

Most people will tell you that it's not a good idea to import your
pictures into the database, if you can avoid it. Unless you take some
rather complicated and unusual steps, storing pictures in a database
leads to enormous bloat, because Access *always* saves the image in
bit-map format *along with* the original JPEG image data. It's simplest
to keep the image files external to Access, usually in a folder
designated for the purpose, and save only the name of the image file, or
the full path to the file, in the database. Then the image can be
displayed on demand by setting the Picture property of an unbound Image
control to the path to the file.

If you insist on storing the image data inside the Access database, have
a look at Larry Linson's image-handling examples at:

http://accdevel.tripod.com/imaging.htm

Among others, he shows a technique for storing an image file as a BLOB
in the database and extracting it as needed, thereby avoiding bloat.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)