Database Size for Access 2002

  • Thread starter Thread starter Daisy
  • Start date Start date
D

Daisy

I've heard there were problems with having a Database
larger then 2 GIG's in Access, is this still true?
 
Daisy said:
I've heard there were problems with having a Database
larger then 2 GIG's in Access, is this still true?
Click to expand...

Not so much a problem, it's that it can't be done. 2 GB is the limit.
 
I've heard there were problems with having a Database
larger then 2 GIG's in Access, is this still true?
Click to expand...

That is still the maximum allowed size for a database, in 2002 and
also in 2003.

If you have pictures in your database, be aware that Access handles
them VERY inefficiently; most developers store graphic images in
external files and just store the path and filename in a small text
field in the database.

If you have over 2 GByte of text/numeric data you should really be
working in a true client/server system such as SQL/Server, Oracle or
the like.
 
Back
Top