Max. Capacity of Access 2000 database

T

Tony Lam

I have created a database for photos and document. Now the total memory the
database is 2.095 GB. It has exceeded the max. cap. of 2 GB. When I try to
save photos and the system pop up with error message. Please let me know the
followings. Thanks.

1) Is there any way to store photos in Access 2000 with less memory ( A
typical photo takes 2 to 3 MB)?
2) At least 10 GB is required for the the database to hold pictures and
document. Is there any way to do it , e.g. split database, or increase the
max. cap of Access 2000 etc ?
 
T

Tony Lam

Joseph,

Thanks for your advice. My program is for shipment inspection alerts and
document., not purely for photo albums. Anyway, I will take a look at the
Adobe's Elements 3, and Thumbs to see if they fit to my purpose.

Tony
 
D

david epsom dot com dot au

1) Is there any way to store photos in Access 2000 with less memory ( A
typical photo takes 2 to 3 MB)?
Click to expand...

Yes, if you really really need to, you can store photos
as binary blobs, rather than as photo's.
2) At least 10 GB is required for the database to hold pictures and
document. Is there any way to do it , e.g. split database, or increase the
Click to expand...

Yes, you can create 10 different databases (perhaps
you have some logical way of dividing the data), and
one database that only has an index to each photo.
(or one database that only has an index to each photo,
and all the photos saved as files in an ordinary
folder).

(david)
 
F

Frank Stepanski

Hi,

how are your display your images? You can store youir images in seperate
folders and just have a link to them in the database itself.

Frank Stepanski
 
Top