Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

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

April 26, 2017based considerations MS ODBMS RDBMS reviewed Standards

0

Posted

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

1 Answer

0

Posted

Location: http://www.jguru.com/faq/view.jsp?EID=104132 Created: Jul 17, 2000 Modified: 2000-07-25 18:03:43.437 Author: James House (http://www.jguru.com/guru/viewbio.jsp?EID=104094) Question originally posed by Joe Sam Shirah PREMIUM (http://www.jguru.com/guru/viewbio.jsp?EID=42100 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.