Max file size in Access 2003

[Ben Barak]

Does anybody know what is the largest allowed file size?
In Access 2002 it is 2 GB and it is giving us a headache.
Thanks.

 

[Douglas J. Steele]

I would expect it to be 2 GB in 2003 as well, since they're still using the
same Jet 4.0

Why is your file so big, though? Are you storing images in it? That's
generally not a good idea.

 

[Larry Linson]

Does anybody know what is the
largest allowed file size? In Access
2002 it is 2 GB and it is giving us
a headache.

Ah, I won't sell my stock in over-the-counter drug manufacturers, then --
the limit remains at 2GB, as Doug said.

Assuming you have been diligent to regularly compact your database, and
can't reduce the size by that method, you can extend that limit by linking
tables in other Access databases, each of which can be 2GB.

Chances are you'll run out of disk storage and processing horsepower before
you run into the limit. My recollection is that you can link tables in up to
255 databases, but there may not actually be such a limit.

Larry Linson
Microsoft Access MVP

 

[david epsom dot com dot au]

you run into the limit. My recollection is that you can link tables in up
to

255 databases, but there may not actually be such a limit.

Likely there is a limit on the number of different simultaneous connections,
rather than on the number of link definitions.

So if you put one 2GB AVI in each MDB, you will be limited by the
number you can simultaneously play, not the number you can list...

(david)