What considerations should be reviewed when using MS Access as opposed to a standards based RDBMS/ODBMS?

James House

1 - Access is very limited as to the number of records it can manage. Once the database gets to be near the size of 1 megabyte, Access is notorious for data corruption.

2 - Access is not "thread safe" - only one connection to the database can be used at a time.

3 - Access has poor performance (speed-wise.)

4 - Access does not support complicated SQL joins and other features.