Maximum length

[Paulo R.]

Hi,

I'd like to know what's the maximum length in MB that an
access 97 database can support with no problems. I
remember of reading something that is supposed to support
1 GB, but i have a database in here that is greater than
2,5 GB and i'm getting some strange errors on it.

Can anybody help me?

Thanks,
Paulo R.

 

[John Vinson]

Hi,

I'd like to know what's the maximum length in MB that an
access 97 database can support with no problems. I
remember of reading something that is supposed to support
1 GB, but i have a database in here that is greater than
2,5 GB and i'm getting some strange errors on it.

Can anybody help me?

2.5 GByte... no wonder you're having problems! I'm amazed it works at
all.

Take a look under "Specifications" in the online help. You'll find
that an Access97 database is limited to 1.0 GByte.

Has this database been compacted? How did it get so big - do you
perhaps have pictures stored in it? If so be aware that Access is
horribly inefficient at storing image data; most developers don't do
so at all, instead storing images in separate files and storing the
path and filename in a Text field.