Apr 14

Microsoft Access Videos from the SharePoint Conference

Microsoft Access ProductsMicrosoft SharePointThe Microsoft Access team has released videos of their presentations at the SharePoint Conference from Las Vegas, NV.

With Access 2013, Access web solutions are hosted in SharePoint and rather than using SharePoint lists as they did in Access 2010, they use a real SQL Server database hosted in SQL Azure. The database can also be linked from desktop copies of Access to create hybrid solutions that serve both the web and Windows.

The Microsoft Access program managers presented these four sessions:

Enjoy!

Other Videos from FMS

Aug 07

Microsoft Access and Office 2010 Service Pack 2 (SP2) Enhancements and Issues

New Paper: Microsoft Access and Office 2010 Service Pack 2 (SP2) Enhnacements and Issues

Microsoft has released Service Pack 2 (SP2) for Microsoft Office 2010. It includes enhancements to Access, Excel, Groove, Office. Outlook, PowerPoint, Project, SharePoint, Visio, Word, and more.

Read our new paper listing:

  • Links to the Download and List of Enhancements
  • List of Updated Products
  • Microsoft Access Enhancements and Fixes:
    • Microsoft Access Object Issues
    • Repair and Compact Issues
    • Microsoft Excel Related Issues
    • Access Web/SharePoint Issues
    • Windows 8 64-bit Issue
    • Runtime Version
  • Known Issues from Microsoft
  • A Confirmed Bug between MS Access 2010 and SharePoint 2013
  • Additional Resources for Microsoft Office and Office 2010 SP1
Jun 07

Comparison of Microsoft Access, LightSwitch and Visual Studio Platforms for Database Developers

Last month I spoke at the Portland Access Users Group Conference at Silver Falls State Park. I gave a presentation introducing Visual Studio LightSwitch and how it could be used for SQL Server applications deployed on a variety of platforms. As a follow-up, I’ve created a summary matrix and discussion that highlights the features and limitations of the variety of platforms from Microsoft Access, Visual Studio LightSwitch, and Visual Studio.


Microsoft Access started at the beginning of the Windows revolution 20+ years ago and became the most popular database of all time. More recently, additional technologies have become significant, so it behooves the Microsoft Access community to be aware of the trends and options.

Database Platform Matrix

Ultimately, it’s about being able to create solutions that help you and/or your users accomplish their mission. Sometimes the user’s platform is critical, sometimes, it’s the data source, and other times it’s the permissions you have to deploy a solution. A variety of platforms and options are available with benefits and limitations with each. Meanwhile, Microsoft Access is also evolving with their latest Access 2013 version offering new web based solutions.

We’ve written a new paper Comparison of Microsoft Access, LightSwitch and Visual Studio Platforms for Database Developers  that summarizes what we’re seeing and experiencing.