Allowed # of Rows in Access Table 1

[dianemarie]

Hello, does Access allow a specific number of rows in a table (for instance, Excel allows 65,000ish), or is a table determined by size? Help gave Access specifications as a recordset being 1 gigabyte, but I'm not quite sure if that is answering the question. Thank you.

 

[carrr]

You're not restricted as to rows, merely database/table size. MS Access 2000 allows for a 1gig limit on tables, 2 gig on databses.
refer here for more spec info:

http://simply-access.com/overview.html

 

[dianemarie]

Thank you so much for the quick answer.