Can anyone tell me the maximum records that an access table will hold?
Thanx
Franca
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
-
Can anyone tell me the maximum records that an access table will hold?
Thanx
Franca
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
-
Re: access database
There is no specific limit.
For A2000 onwards the mdb file can be upto 2GB in size.
Regards
Peter Russell
Franca Petroce previously wrote:
[color=blue]
>
> Can anyone tell me the maximum records that an access table will hold?
> Thanx
> Franca
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>[/color]
-
Re: access database
"Franca Petroce" wrote
[color=blue]
> Can anyone tell me the maximum records
> that an access table will hold?[/color]
No, no one can give you that information*, because there is no limit on
number of records; the maximum size of a single table is just under 2 GB
because the maximum size of a single database is 2 GB. You can link to
tables in other databases, however, to exceed a total size of 2 GB. There's
a brief article on linking tables at
http://accdevel.tripod.com/linktabl.htm.
* From the fields and their types, you can determine
the storage requirements for the data itself, but
there is some "overhead" for pointers, and the
structure of the database, that Microsoft does not
document, so we can't even calculate an estimate.
Good luck with your project.
Larry Linson
Microsoft Access MVP
Comment
Comment