Record Limit in Access 2000?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does any one know if there is a record limit in a table in Access 2000

Also, is there a recomended limit

Thx in advanc
Billy
 
There's no limit in terms of number of records, only in terms of how big the
MDB can be (which is 2 gigabytes).

Try looking in the Help file under Specifications.

And I don't believe there's any official recommended limit, since database
performance is too closely linked to the quality of the design and
implementation of the data model.
 
And I don't believe there's any official recommended limit, since database
performance is too closely linked to the quality of the design and
implementation of the data model.
Click to expand...

I've known of people who felt obliged to move to SQL/Server at 20,000
records (for a variety of reasons, but performance was an important
one); and there's the famous Access 2.0 app with 20,000,000 records in
one table. Different strokes for different folks!
 
I think the number of concurrent users is a bigger concern than the size of the tables.
Click to expand...

The formal limit is 255 simultaneous users. In practice, in a
well-designed app, a hundred or more *read-only* users can work
together; you may run into conflicts frequently if more than twenty or
thirty users are concurrently updating data. And with A2000 and later,
you can have only ONE developer updating the user interface.
 
Back
Top