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.

0 Comments  (click to add your comment)
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

About | Sitemap | Contact