Database Sizing & Linking Pictures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 18 Jun 2004 15:26 GMT

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?

Reply to this Message

Jay Vinton - 18 Jun 2004 19:54 GMT

> 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

Reply to this Message

Jim - 18 Jun 2004 20:11 GMT

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-----
>> large, I find I am wrong. I need to be capable of placing
[quoted text clipped - 4 lines]
>
>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
>.

Reply to this Message

Jay Vinton - 19 Jun 2004 04:11 GMT

> 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

Reply to this Message