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 (www.ukaug.co.uk
) 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; www.upsizing.co.uk
(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 www.AccessHosting.com
to deliver hosted Access Databases in SharePoint 2010 Server.
In this talk we will contrast and compare developing WebForm applications using Visual Studio 2008 with different types of datasources. We will be looking at design issues relating to concurrency control and updateability when using key Visual Studio controls such as the FormView and ListView controls. So if you don’t know where to start in choosing between SQL, LINQ and Entity datasources then you will by the end of this talk. We will also take a look at techniques for the seamless integration of ASP.net security with SQL Server Login security for web applications using LINQ.
Access Web Databases are hybrid supporting a native client Access application and a pure browser based interface to a SharePoint host. This session looks at design and conversion issues.