Language: Deutsch English

Last Update: 2017 - 03 - 20

Access DevCon 2017 - On Video

On Saturday and Sunday April 1st and 2nd, 2017 the very first international Access Developer Conference, Access DevCon, took place.

Some of the world’s leading Microsoft Access Experts and Microsoft Access MVPs came to Vienna, Austria to share their outstanding knowledge about advanced Access and VBA Development with an international audience of Microsoft Access Professionals and Enthusiasts.

As a welcome addition two members of Microsoft’s Access Team took part in the conference to present the news in Access 2016 (those added after the initial release!) to the audience and gather feedback from the attending Access Users.

The full agenda is listed at the Access DevCon Website.


  • You did not know of Access DevCon?
  • You couldn’t attend due to other commitments?
  • Travel to Vienna was too expensive and time consuming?

It was an exciting experience to attend the live conference and meet all those nice, friendly and knowledgeable Access People in person. - But here is the next best thing:

Get the conference on video!

In cooperation with the conference organizer, long-time Access MVP Karl Donaubauer, I recorded the presentations on video.

Here is your opportunity to get the latest news from the Access Team, expand your personal knowledge about Access, VBA, SQL Server, JSON and other exciting technologies.

Watch all the presentations of the conference from the comfort of your office or living room!

If you are here already, you absolutely have to take a peek at the trailer…


You like what you saw in the trailer?

Buy the whole conference package for only 89 EUR (98 USD)!

Here is what you get…

  • … video recordings of all the presentation, more than 10 hours of Access Knowledge in total.
  • … stream the videos on your computer, tablet or even your mobile or internet connected TV.
  • … download all videos DRM-free in SD- or even HD-Quality for your personal use.

The full conference package includes the exclusive presentation of members of the Microsoft Access Team!

You save 32 EUR. (Compared to purchasing all the presentations individually.)

Full conference package

Your purchase will be safely processed by our video hosting partner

If you’ve got any concerns, go over to our Video on Demand page at Vimeo to complete your purchase there.



You rather want to pick and choose individual videos then buy the full package? - No problem at all

Buy any of the presentations for only 15 EUR (~16.50 USD)!

Each of the presentations provides a lot of value on its own. Here is the full list of the individually available recordings.

Access Flows - Thomas Pfoch, picoware, wizard from Berlin, Germany (+Karl Donaubauer, beautiful assistant)

Ever seen a fast&fluid Access touch app on a tablet?
Ever seen a responsive native Access treeview - no API/DLL/OCX?
Watch us present features no one would expect in Access.

•  A real world touch app that doesn't look like Northwind
    •  Techniques and tricks that make an Access app swipe-able and touchy ;-)

•  The latest version of THE native Access treeview
    •  Learn to implement a file explorer treeview with 8 lines of VBA
    •  Observe a treeview combobox and a herd of treeviews working together on a form
    •  See a ton of functions, properties and design options that make the difference
        ... and there will certainly be a substantial discount for attendees

Access Flows - Thomas Pfoch

Access Strategies - Luke Chung, FMS, Vienna (Virginia), USA

As long-term president of the biggest producer of Access tools, Luke has the most substantiated "industry" view of the product. His ideas on important strategic aspects lead to lively discussions.

• The current position of Access inside organizations and in the market
• How things have changed over the many years and technical / structural evolutions
• How to fight the everlasting image problem
• Why are there so few professional Access tools and tool producers
• What Microsoft should do to improve the status of the product
• What Access professionals and communities can contribute

Luke Chung - Access Strategies

Optimizing Access with SQL Server online - Juan Soto, IT Impact, Chicago, USA

Advanced topic on how to configure Access to work with a cloud hosted SQL Server. During this session we will discuss pitfalls to avoid and optimization techniques in order to get Access working great even if the data is web hosted.

•  What to avoid doing when your data is in the cloud, sometimes perception is as important as reality
•  What speed standard should you shoot for and how can it be achieved? (overcoming web latency)
•  How to avoid using JET or ACE engine in queries and in your code. (Hint: Maximize the use of SQL
    Server resources.)
•  Advanced TSQL techniques for the Access developer.
•  SQL Server Security Best Practices, because you never know who might be listening…

Juan Soto - Optimizing Access with SQL Server online

Two Professional Tools to Extend Access Development - Kevin Bell, COMC, Redmond, USA

Git with OASIS-SVN

Our company works on large projects with multiple developers. So we need to manage the development source code. The newest version of OASIS-SVN now offers tighter integration with Git repositories:

•  A few basics of source code control with Access
•  Configuring Git with OASIS-SVN and
•  Managing objects, versions and dealing with conflicts

Kevin Bell - Git with OASIS-SVN


To complement our Access frontends for SQL Server we need web/mobile frontends. Microsoft has tried (and failed) from DAPs to Access Web Apps, and PowerApps are still a toddler. However there is a professional tool from Microsoft that will allow you to access your data remotely and will surprise you with its ease of use: ASP.Net MVC

•  What is Model View Controller and how can you leverage it with your SQL Server databases
•  Building a MVC project with Visual Studio
•  Automatically generating Models and Controllers from an existing database
•  Creating and customizing Views

Kevin Bell - ASP.Net MVC

Access Challenges - Luke Chung, FMS, Vienna (Virginia), USA

25 years of development work with Access mean dealing with a bunch of product bugs and limitations, solving design issues and developing best practices in many fields.

•  Math inaccuracy in Access/VBA
•  Find bad object references and unused objects or code
•  Handling temporary data
•  Dealing with Access design issues
•  Anchoring versus resizing
•  Database compacting and disaster recovery
•  ... and many more

Luke Chung - Access Challenges

Communicating with JSON Services Natively in Access VBA - Peter Bryant, Corylus Business Systems, Cambridge, UK

Access can talk to HTTP services, but doesn't provide built-in abilities to deal with the data from JSON or XML API calls. Whilst there are third party tools and libraries out there, they have their limitations and might not be permitted or welcome on a project (which is how this came about). We show how to do it in Access VBA with a few standard references and no other external dependencies.

•  An introduction to JSON and API web services that use it
•  Why do it internally in Access, and what you need to know before you start
•  How to deal with the API specification (and how some might vary)
•  Using POSTMAN to get a grip on the API (and save a lot of time later!)
•  Using the API schema in code (separation of generic functions and schema specific code)
•  Demonstration and walkthrough of a sample database (which will be made available after the event)
•  So that’s JSON – can you do something similar with XML? (tl;dr – yes!)
•  If time permits – an XML demonstration (which will also be made available after the event)

Peter Bryant - Communicating with JSON Services Natively in Access VBA

Techniques+Tricks for Access Pros - Anders Ebro, Exacto, Copenhagen, Denmark

Image Handling
How would you like to handle 30.000 images in your Access database, many of them 2+MB in size?
Let's further complicate that by placing you off-site on a slow internet connection. Challenge accepted!

•  Tips to storing images
•  Resizing thumbnails
•  Loading images on demand
•  Creating a local image cache

Every day we work with classes, the form class, the textbox class or the combobox.
But have you ever tried taking it one step further by enhancing one of those classes?

•  Reusable GUI enhancements for the textbox, form, combobox
•  Example of custom class that combines 3 controls to support business logic

Using a report inside a form
•  Pretty notes that scale in size
•  Continuous supreports inside continuous subreports but viewed as a form

Anders Ebro - Techniques+Tricks for Access Pros

Automated Testing in Access Applications - Paul Rohorzka, TechTalk, Vienna, Austria

Your application works great, your code is clean, your customer is happy. But all of a sudden weird behaviour starts creeping in, bugs show up, things get broken that worked before. And painfully even users start reporting problems, because you didn't notice that nasty side-effect of your latest change.

But who could test the gazillion of features of a complex application?

To prevent situations as described above, automated testing can help a lot. While it is hard or even impossible for a human to test all features of an entire application, automated tests could at least check the correct behaviour of the most critical parts of the software with the click of a button. A reliable suite of tests can greatly improve the confidence in changing the software and the happiness of the users.

•  A quick introduction to automated testing
•  Kind of tests, TDD, Test-First, Red/Green/Refactoring, Mocking
•  Readability of tests
•  Where to put the effort?
•  Tooling for UnitTesting in Access (AccUnit, Rubberduck)
•  Testing for error conditions
•  Testing in Access can be hard
•  Examples from the wild
    •  Classical unit tests
    •  Testing external communication with a RESTful-service
    •  Testing interaction via the mouse
    •  Testing with data

Paul Rohorzka - Automated Testing in Access Applications



You’re not sure yet? - You can read my personal account of the conference to get further information. And here is another free bonus video from the conference.

"NuGet" for Access - Open discussion hosted by Kevin Bell

An introduction and open discussion on creating a package manager for Access. The goal is to offer a community driven platform that allows people to market their Access related tools or utilities to other Access users with minimal effort. Similar to what NuGet does for Visual Studio.



Slides and Demos

Subscribe to the newsletter to get access to the slides and demos provided by the speakers at the conference.

(You need to use the subscribe form on this page, to get the free downloads!)

Share this article: Share on Facebook Tweet Share on LinkedIn Share on XING

Subscribe to my newsletter


I will never share your email with anyone. You can unsubscribe any time.

© 1999 - 2017 by Philipp Stiefel