Access 2010 Web Databases in SharePoint 2010 underwritten by SQL Server. Why bother?

For many organisations Access Databases have offered a rich user experience yet posed a thorn in their side when it comes to controlling and managing what is produced. With Access 2010 organisations now have the opportunity to both move the data into a more secure repository built on SQL Server through a SharePoint 2010 Enterprise Server Interface, yet also maintain the client applications. The new Access Web Databases are hybrid in that they both support a native client Access application and a pure browser based interface to the SharePoint host.


Access 2010 Web Databases offer the opportunity to exploit the fantastic RAD capabilities of the product and yet allow business level users for the first time to develop a solution which can be delivered through a browser interface.


Detailed topics


Relational database structure vs. SharePoint Lookups and Relationships.


How to migrate existing applications.


RAD fast with Access 2010 deploying a web browser interface, setting new standard.


Macro Programming and more advanced topics.

Presented by Andrew Couch at SQLBits VII
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Andrew has been developing with Access and SQL Server for over 14 years and specialises in Client-Server design applied in the manufacturing and banking sectors. Andrew is a director and one of the founding members of the Access User Group ( and technical director of the Office User Group; having acted as magazine editor, running the web site and on many occasions as a guest speaker. Andrew is the author of the popular Migration Upsizing SQL Tool MUST; (site features a number of detailed technical articles on upsizing Access databases to SQL Server) and is also a MVP for Office Access. Recently Andrew has been engaged by Microsoft Press as a technical reviewer on Access 2010 Inside Out, and has also entered into a buiness partnership with to deliver hosted Access Databases in SharePoint 2010 Server.
  • Video
    The video is not available to view online.