size constraints of 2007

  • Thread starter Thread starter JRough
  • Start date Start date
J

JRough

I've been reading Allen Brownes links for upgrading to Access 2007
which is extremely helpful thank you. The one thing I'm looking for I
can't find. I thought I read that there are some increases in size in
2007. That would seem like a major reason for converting. FOr
example, a general rule is 100,000 records and 15 concurrent users for
<= 2003. Does this increase at all for 2007? I realize there is a
bigger memo field or something

thanks,
 
I'd really question your "general rule". I've worked with databases with
millions of records. 100,000 really isn't very much for any version of
Access.

Bottom line is that the size limits for Access 2007 are the same as for
Access 2000 and newer: the mdb (or accdb) file cannot be larger than 2 Gb.
 
I've been reading Allen Brownes links for upgrading to Access 2007
which is extremely helpful thank you. The one thing I'm looking for I
can't find. I thought I read that there are some increases in size in
2007. That would seem like a major reason for converting. FOr
example, a general rule is 100,000 records and 15 concurrent users for
<= 2003.

I'm not sure where you got that rule, but it's Wrong. The limits in 2000,
2002, 2003, and 2007 are the same: no explicit limit on number of records; 2
GByte in the entire database; 255 users. Practical limits may be smaller and
will vary (dramatically) from one application to another; I know of one
application in Access 2.0 with 20,000,000 rows in a table, but in practice
over a million rows or 25-50 users should encourage one to consider using
Access as a frontend to SQL/Server. This may be a bit easier with 2007, and
with the availability of SQL/Express, you may not need a full SQL 2005
installation.
Does this increase at all for 2007? I realize there is a
bigger memo field or something

Nope. Still 2 GByte, just as it has been since A95.
 
John W. Vinson said:
Nope. Still 2 GByte, just as it has been since A95.

<picky>
Actually, I don't believe the limit was increased from 1 Gb until Jet 4.0,
or Access 2000.
</picky>
 

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

Back
Top