[AccessD] How Access actually accesses SQL Server data

Mark Simms marksimms at verizon.net
Thu Jan 19 09:39:17 CST 2012


My benchmarks using AC2003 a few years ago:
Query Select speed: 2 to 3x faster with SQL Server
Insert/Update speed: 5-10x slower with SQL Server.

Always use SPROCS for inserts/updates....and probably deletes.




More information about the AccessD mailing list