Updated 5/3/2011: Added links to a downloadable Northwind.mdb file for upsizing to SQL Server or SQL Azure with the SQL Server Migration Assistant (SSMA) for Access and a NwindAzure.mdb front-end for a publically accessible SQL Azure cloud database. Changed date and title of the 5/23/2011 Webcast to Moving Access Tables to SharePoint 2010 or SharePoint Online Lists and added a “Web Databases with SharePoint Online” topic.
Updated 3/30/2011: Changed from WebEx to pre-recorded Webcast format. The first Webcast is available on-demand by clicking the headline below and completing the registration form.
Over this and the next two months, I’ll present the following free 45-minute to one-hour Webcasts about advanced Microsoft Access topics for Que Publishing:
Upsizing Access 2010 Projects to Web Databases with SharePoint 2010 Server
Presented by Roger Jennings
Tuesday – March 29, 2011
– 12:00 pm ET Prerecorded – Available on Demand
Microsoft Access 2000, 2002 and 2003 offered intranet connectivity by means of Access Data Pages (DAP), which Access 2007 and 2010 no longer support. Access 2010 introduces the capability to easily publish Access *.accdb applications to Web Databases that run on SharePoint Server 2010’s Access Services.
If your organization doesn’t have a SharePoint Server 2010 license, you can subscribe to low cost, on-demand instances provided by Office 365 or independent Microsoft partners, such as AccessHosting.com. Use SharePoint security to establish read and read/write access to your on-premises or hosted project. In this Webinar, you’ll learn how to:
- Generate a Web Database-compatible application from an Access template
- Modify an existing Access app to comply with Web Database requirements
- Subscribe to trial Office 365, AccessHosting.com, or both hosting services
- Publish your application to on-premises or hosted services with a wizard
- Establish role-based authentication and authorization security for intranet, Internet, or both types of users
Register here to watch the 45-minute Webcast.
Update 3/30/2011: Problems with image size/quality and the missing player slider have been fixed.
Presented by Roger Jennings
Tuesday – April 26, 2011 –
12:00 pm ET Prerecorded – Available on Demand
Microsoft SQL Server has been the preferred back-end database for heavy-duty, multiuser Access applications since Access 2000 introduced the capability to link to the Microsoft Data Engine (MSDE). Microsoft Access 2007 and 2010 don’t support user- and group-level security for new multi-user database projects, so it’s more important than ever to use the SQL Server Migration Assistant (SSMA) for Access to move to SQL Server databases, which maximize data accessibility, reliability and security.
In this Webcast, you’ll learn how to:
- Download and install no-charge SQL Server 2008 R2 Express and SQL Server 2008 R2 Management Studio (SSMS) Express to manage on-premises database back ends
- Download and install the SQL Server team’s free SSMA, which substitutes for Access’s Upsizing Wizard in linking scenarios
- Use the SSMA to link existing Access queries, forms, and reports to a SQL Server 2008 R2 Express database.
- Establish security with user logins and database roles you create in SSMS.
- Obtain a 30-day free trial subscription to a 1-GB SQL Azure Web database that you can convert to a $9.99 per month paid subscription
- Use SSMA to create a SQL Azure server with a trial subscription.
- Use the SSMA to link existing Access queries, forms, and reports to the trial SQL Azure database running in a Microsoft data center.
- Use SSMS to add security with SQL Azure user logins and database roles.
You can download Northwind.mdb for upsizing to SQL Server and SQL Azure from my Windows Live Skydrive instance here.
You also can download NwindAzure.mdb, which is a Access front-end for tables linked by a publically accessible Northwind SQL Azure database, here. Running NwindAzure.mdb will open a connection to the Northwind database running in Microsoft’s South Centeral US (San Antonio, TX) data center.
Moving Access Tables to SharePoint 2010 or SharePoint Online Lists
Presented by Roger Jennings
Monday – May 23, 2011 – Prerecorded – Available 12:00 pm ET
The Microsoft Access Team recommends using SharePoint lists as the shared data source for secure multi-user queries, forms and reports. If you don’t have access SharePoint Services v3 for Windows Server 2003 [R2] or SharePoint Foundation 2010 for Windows Server 2008 [R2], your network administrator can install one of these no-charge add-ons in a few minutes. In this case, your IT department is responsible for backing up and managing your data.
Alternatively, you can subscribe to Microsoft’s low-cost Office365 (formerly Business Productivity Online Suite, BPOS), which now includes a hosted SharePoint instance, or to an instance provided by a Microsoft partner. In this case, the provider assures your data is backed up and always available. The SharePoint administrator manages read and update permissions for data. In this webcast, you’ll learn to:
- Create a SharePoint-compatible application from an Access template
- Modify an existing Access app to replace relationships with SharePoint lookup tables
- Subscribe to trial Office 365 SharePoint hosting services
- Move your application’s tables to hosted SharePoint services with a wizard
- Synchronize locally-stored (cached) copies with the master SharePoint list data
- Establish role-based authentication and authorization security for intranet users
- Upsize Access applications to Web Databases with SharePoint Online.
About the Author
Roger Jennings is an author and consultant specializing in Microsoft .NET, SQL Server, and Access database applications, as well as Windows Azure and SQL Azure cloud computing projects. He was a technical beta tester for all 10 editions of Microsoft Access; SQL Server 6.5, 7.0, 2000, 2005, 2008, and 2008 R2; every release of Visual Basic since version 2.0 and Windows 3.1; and all subsequent Microsoft Windows operating systems. He also was one of the founding members of Microsoft’s former Access Insiders group. Roger is a principal of OakLeaf Systems, a Northern California software consulting firm. He’s the author of many Que titles such as Microsoft Access 2010 In Depth and the curator of Roger Jennings’ Access Blog and the OakLeaf Systems blog.