Maximum rows in Table 1

[jestrada101]

What the limit of rows in a table on Access?

 

[Golom]

There is no specific numeric limit on the number of rows. The limits are that an Access database cannot exceed 2 GB for Access 2K+ or 1 GB for Access 97.

 

[jestrada101]

Thanks!

 

[PHV]

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 FAQ222-2244

 

[willir]

Or check various web sites...
Microsoft Access 2000 and 2002 Maximum Capacities