Maximum size of Access file or mdb

[tomlebold]

The file size of the Access application I'm currently working on is
77,000 MB.
What is the maximum size the Access file or MDB can be?

[Allen Browne]

Max file size is 2GB, so 77MB is nothing to worry about.

77,000 MB might be a problem. :-)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<to*******@msn.comwrote in message
news:11**********************@y66g2000hsf.googlegr oups.com...

The file size of the Access application I'm currently working on is
77,000 MB.
What is the maximum size the Access file or MDB can be?

[fredg]

On 2 Apr 2007 08:59:49 -0700, to*******@msn.com wrote:

The file size of the Access application I'm currently working on is
77,000 MB.
What is the maximum size the Access file or MDB can be?

Look in Help
Index tab + Specification + Access Specifications + Access Database
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[ManningFan]

On Apr 2, 12:04 pm, "Allen Browne" <[e-mail]:

Max file size is 2GB, so 77MB is nothing to worry about.

77,000 MB might be a problem. :-)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<[e-mail] in message

news:11**********************@y66g2000hsf.googlegr oups.com...

The file size of the Access application I'm currently working on is
77,000 MB.
What is the maximum size the Access file or MDB can be?- Hide quoted text -

- Show quoted text -

I thought A97 files could only reach 1GB? I seem to recall files
blowing up on a regular basis at my old job if we didn't compact them
twice a day once they hit 800MB, and I know we used A97 there.

[fredg]

On 2 Apr 2007 11:15:11 -0700, ManningFan wrote:

On Apr 2, 12:04 pm, "Allen Browne" <[e-mail]:

>Max file size is 2GB, so 77MB is nothing to worry about.

77,000 MB might be a problem. :-)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<[e-mail] in message

news:11**********************@y66g2000hsf.googleg roups.com...

>>The file size of the Access application I'm currently working on is
77,000 MB.
What is the maximum size the Access file or MDB can be?- Hide quoted text -

- Show quoted text -

I thought A97 files could only reach 1GB? I seem to recall files
blowing up on a regular basis at my old job if we didn't compact them
twice a day once they hit 800MB, and I know we used A97 there.

You're correct. A97 does have a limit of 1 Gb. Unfortunately the OP
didn't tell us what his Access version is, and the majority of posts
are now for A2000 and newer.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[David W. Fenton]

fredg <fg******@example.invalidwrote in
news:2d*****************************@40tude.net:

You're correct. A97 does have a limit of 1 Gb. Unfortunately the
OP didn't tell us what his Access version is, and the majority of
posts are now for A2000 and newer.

You mean "Jet 4 and newer". It's not an Access limitation -- it's a
Jet database engine limitation.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Scott]

Have you tried to compact your DB?

<to*******@msn.comwrote in message
news:11**********************@y66g2000hsf.googlegr oups.com...

The file size of the Access application I'm currently working on is
77,000 MB.
What is the maximum size the Access file or MDB can be?

[Bob Alston]

Scott wrote:

Have you tried to compact your DB?

<to*******@msn.comwrote in message
news:11**********************@y66g2000hsf.googlegr oups.com...

>The file size of the Access application I'm currently working on is
77,000 MB.
What is the maximum size the Access file or MDB can be?

I have a client who got their MDB file up to about 2 gig. You don't
want to get that big if at all possible.

Their database was so big it could not run compress. I ended up
building an archive process, to create a separate MDB of historical data
and created a new, smaller db with current data. Their database is now
about 125 MB and working well.