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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.