max database size ?

N

Neo

Hello,

i am creating a database which contains image documents as
data using Access 97. the database is expected to be more
than 250MB when all data are loaded.

questions:
1. what is the maximum supported database size for
Access97 ?

2. what is the maximum supported database size for Access
2000 ?
 
E

Exponent

Max file sizes (it is always wise not to get too close to these):

Access 97 - 1GB
Access 2k - 2GB

On storing images in the database:

If you store the images as raw-binary/blobs they will occupy more or less the same space in the database
as they would on disk.

Note, however, that using OLE Embedding can cause a huge storage overhead. With jpeg images this can range
from 10 to 200 *times* the original file size. In this case you would almost certainly hit the size limit.
 
V

Van T. Dinh

1 GB for A97 and 2 GB for A2K but A2K has Unicode (requiring 2 bytes for
each character) so A2K doesn't really double the max. size.

Note that storing images tend to bloat Access / JET database. The preferred
methos is to store the image files separately and only store the pathnames
to the image files.
 
Top