Limitations of Access

[Bruce]

Hello, I would like to know if our current Access 2002
database which is approx 30MB with 25,000 records and
approx. 10 users might be approaching it's realistic
limitations. Should we consider SQL or Oracle at this
point? Thanks for the input.

 

[Douglas J. Steele]

Access 2002 databases can be 2 Gb. 25,000 records is peanuts.

As long as your application is well designed, 10 concurrent users shouldn't
be a problem, especially if most of them aren't updating the database.

 

[John Vinson]

Hello, I would like to know if our current Access 2002
database which is approx 30MB with 25,000 records and
approx. 10 users might be approaching it's realistic
limitations. Should we consider SQL or Oracle at this
point? Thanks for the input.

The limit is 2 GByte (67 times your current size); 10,000,000 records
is getting pretty big. 30 concurrent users is managable if they're all
updating; over a hundred if most are read-only.

So I'd say you're well within Access' capabilities. Compact regularly,
keep current backups, and be sure your forms and queries are well
optimized and you should be fine!