Maximum number of records in an access DB

  • Thread starter Thread starter kbray
  • Start date Start date
K

kbray

Is there a maximm number of records in an access database,
or a point at which the DB will start to run sluggish,
even via ASP entry screens?
 
Is there a maximm number of records in an access database,
Click to expand...

No explicit limit; the .mdb file cannot exceed 2 GByte but it's quite
possible to create a table with tens of millions of records.
or a point at which the DB will start to run sluggish,
even via ASP entry screens?
Click to expand...

Of course there is such a point; it will differ depending on the
indexing of the tables, the design of the queries, the traffic and
capabilities of your network, and the users' tolerance for
sluggishness. In other words... yes, but there's no simple answer!
 
Is there a maximm number of records in an access database,
or a point at which the DB will start to run sluggish,
even via ASP entry screens?
Click to expand...

The speed of the db is usually a function of whether you have designed the
tables properly, including proper "primary keys", and written the queries
efficiently.

HTH,
TC
 
Back
Top