470,609 Members | 1,731 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Simple question???

I just want to know how many records an MS Access database can contain ???

Thank you,

Nov 12 '05 #1
2 1864
"Alain Pelletier" <ni******@nb.aibn.com> wrote in message
I just want to know how many records an MS Access database can contain ???

There is no limit on the record number, only on the *size* of tables and files.
Depending on how many bytes are used per record, you would hit the maximum size at
differing quantities of records.

Technically; Access is not the database. It is the program used to interface with
the database. Out of the box, Access uses either the Jet database engine or the
MSDE. These both have size limitations based on bytes, not record count. In Access
97 the limit of a file is 1GB. In newer versions it is 2 GB. One can theoretically
spread data among multiple linked files and circumvent the file size limitations, but
in general practice, working with that much data in Jet tables is not recommended.

If you use Access against other database engines (SQL Server, Oracle, etc.), then you
have only the limits that those products provide.
Nov 12 '05 #2
> I just want to know how many records an MS Access database can contain ???

There is no definitive answer to you question. The number of records
an Access database can contain is limited by several factors,

- the version of Access/Jet (i.e. an Access 97/Jet 3.x database cannot
exceed 1GB)
- the definition of a record (i.e. an integer data type requires only
two bytes of storage, while a long integer data type requires four
- the quantity and complexity of objects (tables, queries, forms,
reports, macros, modules) in the database
- whether the database is in a compacted state (a database usually
requires less storage space when compacted)

Without a closer examination of the application requirements, it is
impossible to specify how many records a database will hold.

Gordon Rogers
MICO, Inc.

"It's not worth getting into the bullshit to find out what the bull
--Captain Beefheart
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Patchwork | last post: by
1 post views Thread by Proteus | last post: by
2 posts views Thread by Raskolnikow | last post: by
3 posts views Thread by Peter | last post: by
7 posts views Thread by abcd | last post: by
14 posts views Thread by Giancarlo Berenz | last post: by
30 posts views Thread by galiorenye | last post: by
10 posts views Thread by Phillip Taylor | last post: by
17 posts views Thread by Chris M. Thomasson | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.