Database Size

[Guest]

Can Access handle very large databases - 15 million records or more? If so,
is Access 2007 any better at the task than Access 2003? Any suggestions
about how to handle such a large database efficiently would be welcome!

 

[fredg]

Can Access handle very large databases - 15 million records or more? If so,
is Access 2007 any better at the task than Access 2003? Any suggestions
about how to handle such a large database efficiently would be welcome!

It's not the number of records but the combined size of all the records plus
the size of forms, reports, etc.
See
Access Help + Specifications + Access Specifications

Fred

 

[Guest]

Ed,

Personally at that size I would look into using SQL Server or another SQL
Backend. I'm not aware of any table size limitations outside of MS Access
DB's in excess of 2GB seem non responsive... The major problem I could see is
that you will be writing quries to hit this data set... and this could take
FOREVER to get responses.

 

[John W. Vinson]

Can Access handle very large databases - 15 million records or more?

Yes, if properly designed. I'm aware of production databases with upwards of
20,000,000 records, and demonstration databases with five times that. The
limit isn't on record count but on total size - the entire mdb file cannot
exceed 2 GByte, or it'll crash unpleasantly.

If so, is Access 2007 any better at the task than Access 2003?

Probably worse, not better.

Any suggestions
about how to handle such a large database efficiently would be welcome!

It's possible in Access, but you would really do well to consider using
SQL/Server (you can install SQL/Server Express for free if you have Access!!)
or another client/server database such as MySQL. You can still use Access as
the frontend.

John W. Vinson [MVP]

 

[Jamie Collins]

very large databases - 15 million records or more?

See:

What is Large?
by Craig Mullins
http://www.dbazine.com/blogs/blog-cm/craigmullins/blogentry.2006-07-03.2916778719

Jamie.

--