How many records/rows can a MS Access 2000 DB hold

[2Plan]

How many records/rows can a MS Access 2000 DB hold?

 

[PHV]

When in database window ask the help engine for limitations

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[2Plan]

The help engine tells me that a MS Access table can contain 255 fields, but does not tell me how many rows the table can hold?

Thanks for any assistance.

 

[PHV]

A single MDB has a 2Gb overall size limit.
However you may circumvent this limitation with linked tables.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[2Plan]

I understand.
Thanks.