Maximum number of records in an access DB

[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?

 

[John Vinson]

Is there a maximm number of records in an access database,

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?

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!

 

[TC]

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?

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