469,280 Members | 1,950 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,280 developers. It's quick & easy.

Maximum size of Access file or mdb

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?

Apr 2 '07 #1
7 20983
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?
Apr 2 '07 #2
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
Apr 2 '07 #3
On Apr 2, 12:04 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
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.

<tomleb...@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?- 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.

Apr 2 '07 #4
On 2 Apr 2007 11:15:11 -0700, ManningFan wrote:
On Apr 2, 12:04 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
>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.

<tomleb...@msn.comwrote 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
Apr 2 '07 #5
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/
Apr 3 '07 #6
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?

Apr 6 '07 #7
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.
Apr 6 '07 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Joey C. | last post: by
2 posts views Thread by Kums | last post: by
15 posts views Thread by uremae | last post: by
2 posts views Thread by Retheesh | last post: by
12 posts views Thread by Paul Sijben | last post: by
2 posts views Thread by skyy | last post: by
6 posts views Thread by fiefie.niles | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.