max size of database and max row number to hold

[didi]

I want to know the capacity of access database 97 and 2000.
I have an access database which is used for OLAP
solution. One of table has over 2 million rows these days
and I experience significant degradation in the process
speed.
Is it not reasonable to use access when the table gets so
long and large?
Ids there anyone to know the max row count which access
can handle very well?
Of course I understand everything is depend on how large
each row are and what hardware we user etc.

Any suggestion is most welcomed!

 

[Jeff Boyce]

Didi

You've covered some of the issues. Also take into account the number of
users, the type of use, the speed of the network (and the PCs), the amount
of RAM available in the PCs, and the presence and number of indices.

Also, you've experienced "significant degradation", ... but in one function
or all? ?Your definition of "significant" is ...?

You might be at a point where migration to a more robust back end server
(you DO have your application split front/back, right?!) might be in order.

JOPO (just one person's opinion)

Jeff Boyce
<Access MVP>