"Alain Pelletier" <ni******@nb.aibn.com> wrote in message
news:6C******************@ursa-nb00s0.nbnet.nb.ca...
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.