table question

[rkrause]

I have an access2000 database and was wondering if anyone knows the max # of records in a table. and would 100million records cause a problem.

Thanks

 

[pbaldy]

Look up specifications in help for the limits in your particular version. IIRC, A2k is 2Gb overall, 1Gb in any particular table. Depending on what a record contains, that many records might be pushing it.

 

[AxGryndr]

A 100mil is a lot, largest I have worked with was 16mil with no problem.