Database Size for Access 2002

D

Daisy

I've heard there were problems with having a Database
larger then 2 GIG's in Access, is this still true?
 
R

Rick Brandt

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.
 
J

John Vinson

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.
 

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

Error-17099 SMTP Relay Error Problem Entourage 2004 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Access 2002 change report header text 0
Access Lock File .LACCDB / Now shows as a notepad file 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
2 Gig Limit 4
Access Database size limits linking to SQL server 6
Access97 Install 0

Top