What's maximum number of records in a table?

[Scott]

Hello,

What's the maximum number of records I can have in an
Access table? If there's a megabyte size constraint, for
example 2MB per table, what are some of the factors
driving the size of a record apart from the number of
fields?

I'm currently extracting a ton of data from SAP to
analyze in Access. If I surpass Access' capacity, what
other database programs do you recommend that can handle
more records than Access?

Thanks in advance for your help.

-Scott

 

[fredg]

Hello,

What's the maximum number of records I can have in an
Access table? If there's a megabyte size constraint, for
example 2MB per table, what are some of the factors
driving the size of a record apart from the number of
fields?

I'm currently extracting a ton of data from SAP to
analyze in Access. If I surpass Access' capacity, what
other database programs do you recommend that can handle
more records than Access?

Thanks in advance for your help.

-Scott

There is no maximum number of records in Access.
There is a maximum Database Size of
1 GB for Access 97
2 GB for Access 2000 and later.

 

[Cheryl Fischer]

There is no set number of records specified. You can look at all of the
specifications with regard to databases and objects by opening Help and
typing the word specifications in the Answer Wizard

 

[Brendan Reynolds]

The Access 97 Developers Handbook (published by Sybex) explains how to
estimate (it can only be an approximate estimate) the size of a record,
taking into account the various overheads associated with different data
types. I'm not aware of any similar explanation for later versions of
Access, however.

Access makes a great front-end application for SQL Server databases, so if
you do exceed the limit, you can store the data in SQL Server and still use
Access on the front-end.