How to design a database capable of store data (mainly photos) for more than 2 GB?

[edebe]

Hi all,

I would like to ask your help for an issue concerning the creation of a database I'm facing now.

I have to design a database which will contain, for each entry, many photos together with text-base data.
If I design it for storing the images into the file, I do have the issue of the 2 GB limit.

For this reason I would like to ask if somebody could help me to find a solution.

Thank you very much in advance for the help!

 

[Micron]

The general consensus is, never store attachments in Access tables. You keep the attachments in folders and store the path in table records. To use the attachment your form needs the appropriate control - either image control or unbound ole object control if the file being retrieved is not an image.

 

[jackd]

I agree with micron --keep the images in the file system and the location of those images in the database. Associated text in the database.
You'll find similar advice and some samples if you search/google.

See this info from M$oft

 

[edebe]

Thank both for thee suggestion, I will try to make it work in this way.