Database Sizing & Linking Pictures

  • Thread starter Thread starter Jim
  • Start date Start date
J

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?
 
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.
Click to expand...

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
 
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
Click to expand...
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.
 
get the picture to display as a picture in my report or
form. I do not know coding or any other fancy databasing
Click to expand...

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
 
Back
Top