4 ms·
JET's days are long gone. The SQL Server Desktop engine is the underpinning for Access now. It essentially _is_ SQL Server. The biggest limitation? The concurre
by jpitz 13y ago
JET's days are long gone. The SQL Server Desktop engine is the underpinning for Access now. It essentially _is_ SQL Server. The biggest limitation? The concurrent transaction count is limited to 5. There are others, but it is a far, far cry from that prone to corrupt, slow beast JET.
- moron4hire 13y agoJET isn't all that bad. It can be used to run SQL queries CSV files. As an ETL tool it's pretty flexible.
- jrarredondo 13y agoActually, in the latest Office 2012, Access apps are now three tier apps with SQL Server 2012 or SQL Azure backends.
- fusiongyro 13y agoIt's amazing how much things change when you're not paying attention. Thanks for explaining this.
- panderon 13y agoPoint of clarification, concurrent transaction count is limited to 255. http://office.microsoft.com/en-us/access-help/access-2010-specifications-HA010341462.aspx http://office.microsoft.com/en-us/access-help/access-2010-sp...