Importing pictures into Access

[Andrew]

Is it possible to import pictures into a record of a
table? I need to have 3 pictures per record... Can I
import all 3 directly into a specific record or is there
another way to go about it?

Please let me know!

Andy

 

[prabha]

Hi Andy,

You can but keep in mind that your database will bloat as you add pictures
(e.g., grow significantly). An Access database file can to a maximum of 2
gigabytes (minus System tables) thereby the number of pictures will be
limited.

The preferable thing is to use something like in the following article:
ACC2000: How to Display an Image from a Folder in a Form or in a Report
http://support.microsoft.com/default.aspx?scid=kb;en-us;210100

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."



--------------------
| Content-Class: urn:content-classes:message
| From: "Andrew" <[email protected]>
| Sender: "Andrew" <[email protected]>
| Subject: Importing pictures into Access
| Date: Tue, 3 Feb 2004 13:05:03 -0800
| Lines: 8
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcPqmWR3p1TwHE3GS1KxEsUevOXrEw==
| Newsgroups: microsoft.public.access.externaldata
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.externaldata:48555
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.externaldata
|
| Is it possible to import pictures into a record of a
| table? I need to have 3 pictures per record... Can I
| import all 3 directly into a specific record or is there
| another way to go about it?
|
| Please let me know!
|
| Andy
|

 

[GRayL]

Andy: Rather than importing consider linking. In the
table design mode, you can declare a datatype "hyperlink"
which follows the path to your photo filename. I use
Microsoft Photo Editor as the default editor for jpg
files so double-clicking on the hyperlink opens the
picture in Photo Editor. If you need three photos per
record, you need three separate hyperlinks in three
different fields.
I think Access 2000 which I use is limited to 255 fields
per table so you could have 255 pictures per record!

GRayL

 

[Dick]

I have a related problem. I have been embedding pictures
in a field and display that field on a form using insert
PhotoBase Document. Recently an icon rather than the
picture is displayed on the form. This only happens with
the new records; older records still display the
picture. Any idea what my problem may be?

 

[Ptit Fred]

Hi Dick,

The previous images were embedded into you database when xxx program was
installed on your computer that served as the OLE Server for (most likely
JPG) files.

You'll probably need to reinstall Photo Editor, see: Microsoft Photo Editor
Is Removed When You Install Office 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;817095

OR

Change the File Associations for whatever image file that displays as an
icon, example:
- open windows explorer
- select Tool > Folder Options > Files Type
- select the correct extension for your image file
- change Opens with to the correct program

Note: I think your issue is going to be to reinstall Photo Editor

Eric

--------------------
| Content-Class: urn:content-classes:message
| From: "Dick" <[email protected]>
| Sender: "Dick" <[email protected]>
| References: <[email protected]>
<[email protected]>
| Subject: RE: Importing pictures into Access
| Date: Thu, 26 Feb 2004 13:44:16 -0800
| Lines: 88
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcP8sa7iTj4351+oS2qNoXg+oPgdZg==
| Newsgroups: microsoft.public.access.externaldata
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.externaldata:49339
| NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
| X-Tomcat-NG: microsoft.public.access.externaldata
|
| I have a related problem. I have been embedding pictures
| in a field and display that field on a form using insert
| PhotoBase Document. Recently an icon rather than the
| picture is displayed on the form. This only happens with
| the new records; older records still display the
| picture. Any idea what my problem may be?
| >-----Original Message-----
| >Hi Andy,
| >
| >You can but keep in mind that your database will bloat
| as you add pictures
| >(e.g., grow significantly). An Access database file can
| to a maximum of 2
| >gigabytes (minus System tables) thereby the number of
| pictures will be
| >limited.
| >
| >The preferable thing is to use something like in the
| following article:
| >ACC2000: How to Display an Image from a Folder in a Form
| or in a Report
| >http://support.microsoft.com/default.aspx?scid=kb;en-
| us;210100
| >
| >I hope this helps! If you have additional questions on
| this topic, please
| >respond back to this posting.
| >
| >
| >Regards,
| >
| >Eric Butts
| >Microsoft Access Support
| >
| >"Microsoft Security Announcement: Have you installed the
| patch for
| >Microsoft Security Bulletin MS03-026? If not Microsoft
| strongly advises
| >you to review the information at the following link
| regarding Microsoft
| >Security Bulletin MS03-026
| ><http://www.microsoft.com/security/security_bulletins/ms0
| 3-026.asp> and/or
| >to visit Windows Update at
| <http://windowsupdate.microsoft.com/> to install
| >the patch. Running the SCAN program from the Windows
| Update site will help
| >to insure you are current with all security patches, not
| just MS03-026."
| >
| >
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Andrew" <[email protected]>
| >| Sender: "Andrew" <[email protected]>
| >| Subject: Importing pictures into Access
| >| Date: Tue, 3 Feb 2004 13:05:03 -0800
| >| Lines: 8
| >| Message-ID: <[email protected]>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| X-MIMEOLE: Produced By Microsoft MimeOLE
| V5.50.4910.0300
| >| Thread-Index: AcPqmWR3p1TwHE3GS1KxEsUevOXrEw==
| >| Newsgroups: microsoft.public.access.externaldata
| >| Path: cpmsftngxa07.phx.gbl
| >| Xref: cpmsftngxa07.phx.gbl
| microsoft.public.access.externaldata:48555
| >| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| >| X-Tomcat-NG: microsoft.public.access.externaldata
| >|
| >| Is it possible to import pictures into a record of a
| >| table? I need to have 3 pictures per record... Can I
| >| import all 3 directly into a specific record or is
| there
| >| another way to go about it?
| >|
| >| Please let me know!
| >|
| >| Andy
| >|
| >
| >.
| >
|