Pasting Images (Lots!) into Access

[Lia]

Does anybody know how to paste images copied from PDF documents into an
Access database?

Any help is greatly appreciated!!
Lia

 

[Wayne-I-M]

Hi

The simple answer is Yes most people here know how to do this but also that
anyone who does will also know enough about access to know not to do it.

So, don't put your images into your database, or your DB will be become very
big very quickly. In fact the size may detract from the applications speed
and basically make your DB unworkabe.

The best idea is to create another file or folder and then link your
database records to this.

You need to give some more information to get a better answer.

Do you want to link a picture to a record, has each record got more than one
picture, when do you ant to display the pictures - on a form in a report -
how will you identify which pisture reates to which database record,
etc
etc

 

[Arvin Meyer MVP]

Saving images inside of Access, caused excessive bloat. Even without bloat,
the files are of substantial size. Instead save then as files and link to
them. This will help:

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

If you still want to use the images, with no bloat, try:

http://www.ammara.com/

 

[Rich Wonneberger]

Wayne,

If I had a bunch of .pdf files in the same directory as the database, how
would they be opened, with Adobe or can Access show the pdf itself??
The ones I am thinking about can range from from 40 to several hundred
pages
in one pdf.
98% of the time I work with 2 queries. Can one field in a record point to
the pfd and open from the query?

TIA
Rich W