Database Sizing & Linking Pictures

[Jim]

I am trying to create a database that would generate a
catelog, complete with pictures. I thought that if I
linked my photograph that my dtabase would not grow too
large, I find I am wrong. I need to be capable of placing
several hundred pictures into a database without exceeding
the database size limit of 2 GB.

Is there a hero out there with a simple solution for a non-
database expert?

 

[Guest]

large, I find I am wrong. I need to be capable of placing

several hundred pictures into a database without exceeding
the database size limit of 2 GB.

Hi Jim,

You might consider storing the images as files and putting the path\filename in the database. This makes backup/restore more complicated, and it exposes you to some vulnerabilities, such as the devices with the images being offline, but at least the database won't max out.

Jay

 

[Jim]

Jay, first let me thank you for replying and offering a
solution, thank you very much. I have tried using a
hyperlink to keep the pictures in another folder and
reduce the size of my database, but I do not know how to
get the picture to display as a picture in my report or
form. I do not know coding or any other fancy databasing
skill - do you have a simple solution to this? One that a
layman can put to use?

Jim

-----Original Message-----

Hi Jim,

You might consider storing the images as files and

putting the path\filename in the database. This makes
backup/restore more complicated, and it exposes you to
some vulnerabilities, such as the devices with the images
being offline, but at least the database won't max out.

 

[Guest]

get the picture to display as a picture in my report or

form. I do not know coding or any other fancy databasing

Jim,

I should probably check out at this point. This part of the forum is about table design and I know absolutely nothing about using Access for forms or reports.

If I were doing this in VB, I'd use an Image or PictureBox control to display the image on a form, and Crystal or Active Reports to produce the printed catalog.

I'm sure there are plenty of folks here who can give better advice. Or maybe you should re-post in access.forms or access.reports.

Jay