Chapter 14. Using SQL Server

Although Microsoft Access 2010 is the world’s best small-scale database, the product does have limitations; as you add more data or more users to an application, it will eventually run out of steam. It is truly amazing just how far you can push an Access database, but eventually you will begin to have issues with either performance or the stability of the database. The cutoff point will vary, but if we said 200 MB, or more than 20 concurrent ...

Get Microsoft® Access® 2010 VBA Programming Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.