Database size limitation - advanced question

message from Eric Stevenson on 17 May 2004

Does anyone know if there is a way to work around the 2GB
database size limitation on Access mdb's? I have a file
that starts just over 2GB and I was able to trim it back
to 750MB. That file needs to be paired with data that
will likely result in appx a 6-8gb file. I have the
hardware to run this but Access gives me an "Invalid
argument" error. Is there a setting somewhere that I can
use to up the limit???

Douglas J. Steele replied to Eric Stevenson on 17 May 2004

There is no way around the limit. It's a hard limit dictated by the
architecture of Jet.

Is it possible to split your data into smaller chunks, and store each chunk
in a different MDB? From a single front-end, you can link to as many
back-ends as you like.

anonymous replied to Douglas J. Steele on 18 May 2004

I was afraid that was going to be the answer. Looks like 7
db's it is...
dictated by the
and store each chunk
to as many
2GB
can

Albert D. Kallal replied to Eric Stevenson on 17 May 2004

What is the size after you do a compact and repair?

Are you storing graphics inside of the database...as this often does not
work well at alll...

Eric Stevenson replied to Albert D. Kallal on 18 May 2004

Yeah...its a huge file. That is the "compacted and
repaired" size. I am likely going to have to break the db
into 7 parts and link them through 1 interface. Only
issue is that I really wanted it to run in one solid db
and I don't know how to use SQL server
often does not

Albert D. Kallal replied to Eric Stevenson on 19 May 2004

Hum..as mentioned...is this large tables? How many recodes?

As mentioned, you DO NOT want to store pictures..unless you change the way
you transfer the data to a ole field.

If those files are just large numbers of reocrds..then yes..you are
certainly pushing the limits of ms-access...

Archived message: Database size limitation - advanced question (Microsoft Access Database)