Max file size in Access 2003

  • Thread starter Thread starter Ben Barak
  • Start date Start date
B

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.
 
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.
 
Does anybody know what is the
largest allowed file size? In Access
2002 it is 2 GB and it is giving us
a headache.
Click to expand...

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
 
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.
Click to expand...

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)
 
Back
Top