Useful Books:

You're beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic® for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access—and challenge yourself to new levels of mastery! Enhance your application with VBA built-in functions and SQL code Use the Access Object Model to work with data in forms and reports Manipulate data using SQL, queries, and recordsets with Data Access Objects (DAO) Create classes for handling form and control events Connect your Access database to different sources of data Effectively plan how to upsize an existing Access database to Microsoft SQL Server® Dynamically update Microsoft Excel® spreadsheets from the database Migrate your Access database directly to the cloud using SQL Azure™

---

Errata:

Error	Response	Corrected Sample Files
Accompanying text on page 28 and in figure 1-43 reference an intentional error that is supposed to be included in the companion code. The intentional error in fact does not exist in the companion code. The intentional error was supposed to be: If lngPosSpace <>0	The sample database has now been corrected, my thanks to Tom Fulmer.	Chapter1 DatabaseFiles
In the modRST_TableRecordset() code, the With rst sections have rst.Seek statements. Shouldn't the rst be omitted ? Also, top quarter of p. 190, the With rst section has an rst.MoveNext statement.	Inside a With rst....End With block of code you do not need to prefix a recordset operation such as .MoveNext by stating the name of object for example rst.MoveNext. At the bottom of page 192 inside the With statement the line rst.MoveNext can also be written .MoveNext and near the bottom of page 212 the line bk = rst.Bookmark can also be written as bk = .Bookmark The sample database has now been corrected, my thanks to Robert Lundquist.	Chapter5 DatabaseFiles

---

Useful Webcasts/Presentations:

Building Access Applications with SQL Server Databases - 9th August 2011

The best way to get an overview of how to develop with an Access application linked to SQL Server and use the associated tools is to watch someone building solutions. In this session we will be demonstrating the construction of DSN's, linking tables, views, and using stored procedures and views in pass-through queries. This will include a discussion of the benefits in using SQL Server Schemas and Synonyms. Following this we will look at techniques for using local temporary tables, SQL Server temporary tables and resolving performance issues.

Presenting on behalf of Microsoft at the TechDay in London - 2011

This video will provide an introduction to placing an on-premise SQL Server database into SQL Azure and focus on how existing Office Applications used for BI and Application Development can continue to function when directly connected to SQL Azure. We will share our own experiences of assisting companies in moving the data, developing multi tenanted solutions, managing security and refining the application design.

The companion content on the books website should be used for all downloads of the sample databases. Any updates will be posted in this area.