Max. Capacity of Access 2000 database

[Guest]

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 ?

 

[Joseph Meehan]

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)?

Use links to the photos. Don't put the actual photos in the database.

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 ?

See above. That way it will only load the photo needed.

Note: it sounds like you may be using Access for a photo album program.
Frankly I think there are some very nice photo albums out there and you may
do much better with one of them.
I use Adobe's Elements 3, another great one is Thumbs.

 

[Guest]

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

 

[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)?

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

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)

 

[Guest]

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