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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid Argument 5
Add autonumber to a large table? 0
Problems with using/converting Access 2002 to Access 2007 3
database size increase 6
Record-Locking remains open after closing 0
Access 2006; Is 2 Gig database limitation addressed ? 5
Navigation Pane in Access 2002 14
Access database suddenly huge 1

Back
Top