What considerations should be reviewed when using MS Access as opposed to a standards based RDBMS/ODBMS?
Created May 4, 2012
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.
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.