Home
%3CLINGO-SUB%20id%3D%22lingo-sub-725549%22%20slang%3D%22en-US%22%3EAccess%20is%20a%20Hybrid%20Cloud%20Superstar%2C%20part%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-725549%22%20slang%3D%22en-US%22%3E%3CFONT%20size%3D%223%22%3EThis%20article%20was%20written%20by%20George%20Young%2C%20Access%20developer%20and%20.NET%20applications%20consultant%26nbsp%3B%3C%2FFONT%3E%3CH1%20id%3D%22toc-hId-1986241499%22%20id%3D%22toc-hId-1986241499%22%20id%3D%22toc-hId-1986241499%22%3E%3CFONT%20size%3D%225%22%3EAccess%20in%20a%20Cloud-First%20Mobile-First%20World%3C%2FFONT%3E%3C%2FH1%3E%0A%3CP%3EThis%20month%2C%20we%20launch%20a%20regular%20series%20of%20posts%20on%20how%20Microsoft%20Access%20can%20survive%2C%20indeed%20thrive%2C%20in%20the%20brave%20new%20cloud%20and%20mobile%20world.%26nbsp%3B%20We%E2%80%99ll%20start%20with%20this%20introductory%20post%2C%20giving%20some%20background%20and%20context.%20Subsequent%20posts%20will%20be%20looking%20at%20specific%20examples%20with%20steps%20to%20implement%20them.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121505i0992BBEDF26B1390%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22MSC17_data_004.png%22%20title%3D%22MSC17_data_004.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CBR%20%2F%3E%3CH2%20id%3D%22toc-hId--762428967%22%20id%3D%22toc-hId--762428967%22%20id%3D%22toc-hId--762428967%22%3EBackground%3C%2FH2%3E%0A%3CP%3EThe%20computing%20world%20has%20changed%20in%20the%20past%20decade.%26nbsp%3B%20Since%20the%20heady%20days%20of%20Access%202007%2C%20Windows%20ruled%20the%20client%20computing%20world.%20But%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EThere%20are%20now%20more%20Android%20computing%20devices%20than%20Windows%20devices.%3C%2FLI%3E%0A%3CLI%3EEnterprises%20themselves%20are%20demanding%20applications%20which%20can%20run%20in%20this%20heterogeneous%20computing%20world%20--%20remote%2C%20mobile%2C%20on%20iOS%20or%20Android.%3C%2FLI%3E%0A%3CLI%3EMicrosoft%20itself%20has%20pivoted%20to%20a%20mobile%20and%20cloud%20strategy%2C%20under%20Satya%20Nadella%3A%3CUL%3E%0A%3CLI%3ETraditional%20Windows%20applications%20have%20now%20been%20released%20on%20Android%2C%20iOS%2C%20and%20the%20Mac.%3C%2FLI%3E%0A%3CLI%3EAzure%20has%20gone%20from%20nothing%20to%20being%20a%2C%20if%20not%20the%2C%20primary%20growth%20driver%20for%20the%20company.%3C%2FLI%3E%0A%3CLI%3EWindows%2010%20was%20free%20for%20the%20first%20year%20or%20so%2C%20and%20Windows%20itself%20has%20gone%20from%20being%20the%20focal%20point%20of%20the%20company%20to%20being%20split%20into%20two%20separate%20divisions.%3C%2FLI%3E%0A%3CLI%3EMicrosoft%E2%80%99s%20premier%20development%20tool%2C%20Visual%20Studio%2C%20now%20has%20a%20Mac%20version%2C%20and%20supports%20the%20development%20of%20Android%20and%20iOS%20applications.%20Microsoft%20has%20also%20released%20Visual%20Studio%20Code%2C%20which%20runs%20on%20Windows%2C%20Mac%20and%20Linux.%26nbsp%3B%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EThe%20new%20strategy%20appears%20to%20have%20been%20very%20successful%2C%20as%20MSFT%20stock%20is%20up%20over%20200%25%20since%20Nadella%20became%20CEO%20(among%20other%20metrics%2C%20including%20employee%20morale).%26nbsp%3B%20Microsoft%2C%20as%20of%20this%20writing%2C%20has%20overtaken%20Apple%20to%20become%20the%20most%20valuable%20company%20in%20the%20world%20(something%20most%20would%20have%20thought%20unthinkable%20a%20few%20years%20ago).%3C%2FP%3E%0A%3CP%3EMeanwhile%2C%20unlike%20some%20other%20members%20of%20the%20Office%20family%2C%20such%20as%20Word%2C%20Excel%2C%20and%20PowerPoint%2C%20Access%20runs%20only%20on%20Windows.%26nbsp%3B%20Only%20people%20running%20full%20Windows%2C%20a%20diminishing%20proportion%20of%20the%20general%20computing%20market%2C%20can%20run%20our%20applications.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%E2%80%99ll%20recall%20that%20Access%20itself%20was%20removed%20from%20the%20Business%20(as%20opposed%20to%20Enterprise)%20editions%20of%20Office%20365%2C%20but%20later%20returned%20because%20of%20strong%20customer%20demand.%20The%20latest%20attempt%20to%20%E2%80%9Cget%20Access%20on%20the%20web%E2%80%9D%2C%20Access%20Web%20Apps%2C%20which%20launched%20with%20fanfare%20in%20%26nbsp%3BOffice%202013%2C%20was%20terminated%20less%20than%20five%20years%20later.%26nbsp%3B%20Work%20on%20the%20Access%20client%20application%20has%20been%20happening%20recently%2C%20most%20notably%20with%20the%20reworking%20and%20expanding%20of%20data%20connections%2C%20and%20with%20modern%20charts.%26nbsp%3B%3C%2FP%3E%3CBR%20%2F%3E%3CH2%20id%3D%22toc-hId-980381368%22%20id%3D%22toc-hId-980381368%22%20id%3D%22toc-hId-980381368%22%3ESo%2C%20Whither%20Access%3F%3C%2FH2%3E%0A%3CP%3EAt%20first%20glance%2C%20things%20don%E2%80%99t%20look%20promising%20for%20our%20favorite%20database%20application%20and%20development%20environment.%26nbsp%3B%20Looking%20deeper%2C%20though%2C%20there%20is%20great%20opportunity%20for%20Access%20in%20this%20cloud%2Fmobile%20world.%26nbsp%3B%20Let%E2%80%99s%20start%20at%20looking%20at%20what%20Access%20still%20does%20uniquely%20well%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EAccess%20is%20a%20great%20RAD%20database%20designer.%20The%20ease%20of%20setting%20up%20tables%2C%20indexes%2C%20relations%2C%20and%20queries%20are%20unparalleled.%26nbsp%3B%20What%20made%20Access%20so%20popular%20at%20the%20start%20remains%20a%20core%20strength.%3C%2FLI%3E%0A%3CLI%3EAccess%20generates%20great%20rich-client%20data-driven%20applications.%20With%20the%20full%20richness%20of%20Win32%20at%20its%20disposal%2C%20Access%20has%20powerful%20and%20performant%20application%20features%20like%20a%20rich%20set%20of%20form%20controls%2C%20validation%2C%20form%20and%20datasheet%20views%2C%20and%20so%20forth.%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3EAccess%20is%20a%20great%20RAD%20tool%20for%20reports%20and%20charts.%20The%20ease%20of%20development%20and%20power%20of%20Access%20reports%20remain%20a%20key%20strength%20of%20Access.%26nbsp%3B%20Modern%20charts%2C%20introduced%20in%20Office%20365%20%2F%202019%20adds%20to%20this.%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3EAccess%20integrates%20very%20well%20with%20Windows%20and%20Windows%20applications%2C%20notably%20other%20Office%20applications.%20Win32%20APIs%20are%20available%20to%20Access%2C%20and%20integration%20with%20the%20full%20Office%20applications%2C%20such%20as%20sending%20email%20via%20Outlook%2C%20exporting%20to%20Excel%2C%20or%20generating%20a%20Word%20document%2C%20is%20excellent.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EThese%20are%20the%20key%20questions.%20Is%20it%20possible%20to%20hold%20on%20to%20these%20things%20that%20Access%20developers%20have%20loved%20for%2025%20years%2C%20and%20be%20relevant%20in%20the%20new%20cloud%2Fmobile%20world%3F%26nbsp%3B%20Is%20there%20any%20way%20that%20we%20can%20keep%20Access%20and%20yet%20be%20relevant%20on%20iPads%20or%20Macs%2C%20or%20even%20phones%3F%26nbsp%3B%20Or%20does%20Access%20go%20the%20way%20of%20the%20dodo%20bird%3F%3C%2FP%3E%0A%3CP%3EWell%2C%20it%E2%80%99s%20our%20belief%20that%20Access%20can%20do%20fantastically%20well%20in%20the%20cloud%2Fmobile%20world.%26nbsp%3B%20With%20a%20little%20effort%2C%20we%20can%20have%20our%20cake%20and%20eat%20it%20too.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOne%20of%20Microsoft%E2%80%99s%20key%20points%20of%20strategy%20in%20Azure%E2%80%99s%20success%20is%20something%20called%20the%20Hybrid%20Cloud.%26nbsp%3B%20Essentially%2C%20this%20means%20the%20best%20of%20Windows%20and%20the%20best%20of%20the%20cloud%2C%20working%20together.%26nbsp%3B%20It%E2%80%99s%20not%20a%20stretch%20to%20say%20that%20Access%20is%20one%20of%20the%20best%20things%20in%20Windows.%20In%20the%20coming%20months%2C%20we%E2%80%99ll%20take%20a%20close%20look%20at%20how%20Access%20can%20make%20use%20of%20the%20best%20of%20the%20cloud.%26nbsp%3B%3C%2FP%3E%3CBR%20%2F%3E%3CH2%20id%3D%22toc-hId--1571775593%22%20id%3D%22toc-hId--1571775593%22%20id%3D%22toc-hId--1571775593%22%3EComing%20Posts%3C%2FH2%3E%0A%3CP%3EWe%E2%80%99ll%20be%20breaking%20this%20conversation%20up%20into%20three%20sections%3A%20data%20in%20the%20cloud%2C%20Access%20application%20in%20the%20cloud%2C%20and%20extending%20the%20application%20in%20the%20cloud%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EAccess%20using%20a%20cloud%20database%20for%20its%20backend%20(and%20all%20the%20corresponding%20benefits)%3C%2FLI%3E%0A%3CLI%3EAccess%20applications%20running%20in%20a%20cloud%20VM%20(and%20all%20the%20corresponding%20benefits)%3C%2FLI%3E%0A%3CLI%3EExtending%20our%20applications%E2%80%99%20feature%20set%20and%20reach%20(Power%20BI%2C%20ASP.NET%20web%2Fmobile%2C%20and%20so%20on)%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EThanks%20for%20reading%20and%20stay%20tuned!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSTRONG%3EAbout%20the%20author%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20150px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121506iBCE70AB306C55A02%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20alt%3D%22George%20Young.jpg%22%20title%3D%22George%20Young.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EGeorge%20first%20encountered%20Microsoft%20Access%20when%20using%20the%20thirty-plus%20floppy%20disk%20versions%20of%20Office%20to%20teach%20Statistics%20and%20MIS%20in%20the%20early%201990%E2%80%99s.%20It%E2%80%99s%20been%20true%20love%20ever%20since.%20George%20has%20worked%20as%20a%20software%20developer%20for%20the%20past%20twenty-five%20years%2C%20half%20of%20that%20time%20at%20Microsoft%20(in%20just%20about%20every%20group%20%3CEM%3Eother%3C%2FEM%3E%20than%20Office).%20%26nbsp%3BHe%20is%20now%20an%20independent%20consultant%20(Dawson%20Butte%20Software)%20based%20in%20the%20Denver%20area%2C%20working%20primarily%20on%20.NET%20applications%20for%20public-%20and%20private-sector%20clients%20(often%20with%20Access%20somewhere%20in%20the%20mix)%2C%20and%20actually%20still%20has%20a%20commercial%20site%20or%20two%20that%20is%20driven%20by%20an%20Access%20database%20sitting%20in%20the%20web%20server%20file%20system.%26nbsp%3B%20George%20is%20the%20current%20President%20of%20the%20Denver%20Area%20Access%20Users%20Group%20(%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttp%253A%252F%252Fwww.daaug.org%252F%26amp%3Bdata%3D02%257C01%257CMichal.Bar%2540microsoft.com%257C6d1694cde9534134299a08d6fb206113%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636972513903874353%26amp%3Bsdata%3DDzsW7xQSpX6tPPbbzxkiKkOHGUNrckXIkyKzZeCZb6k%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.daaug.org%2F%3C%2FA%3E)%2C%20and%20has%20spoken%20at%20a%20variety%20of%20conferences%2C%20including%20Access%20Day%20in%20California%20and%20Colorado%2C%20the%202018%20Portland%20Database%20Designer%20International%20Conference%2C%20and%20the%202019%20Microsoft%20Global%20Azure%20Bootcamp%20in%20Denver%2C%20as%20well%20as%20for%20a%20dozen%20or%20so%20user%20groups%2C%20both%20domestic%20and%20international.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-725549%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20the%20first%20of%20a%20regular%20series%20of%20posts%2C%20written%20by%20George%20Young%2C%20an%20Access%20professional%20developer%20and%20a%20consultant%20specializing%20in%20.NET%20applications%2C%20on%20how%20Microsoft%20Access%20can%20survive%2C%20indeed%20thrive%2C%20in%20the%20brave%20new%20cloud%20and%20mobile%20world.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-725549%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E2019%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-783863%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20is%20a%20Hybrid%20Cloud%20Superstar%2C%20part%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783863%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20future%20application%20of%20my%20Access%2FVBA%20skills%20has%20been%20on%20my%20mind%20for%20a%20while.%26nbsp%3B%20This%20article%20has%20my%20attention%20and%20I'm%20looking%20forward%20to%20what%20else%20you%20have%20to%20say.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft
This article was written by George Young, Access developer and .NET applications consultant 

Access in a Cloud-First Mobile-First World

This month, we launch a regular series of posts on how Microsoft Access can survive, indeed thrive, in the brave new cloud and mobile world.  We’ll start with this introductory post, giving some background and context. Subsequent posts will be looking at specific examples with steps to implement them. 

 

MSC17_data_004.png


Background

The computing world has changed in the past decade.  Since the heady days of Access 2007, Windows ruled the client computing world. But:

  • There are now more Android computing devices than Windows devices.
  • Enterprises themselves are demanding applications which can run in this heterogeneous computing world -- remote, mobile, on iOS or Android.
  • Microsoft itself has pivoted to a mobile and cloud strategy, under Satya Nadella:
    • Traditional Windows applications have now been released on Android, iOS, and the Mac.
    • Azure has gone from nothing to being a, if not the, primary growth driver for the company.
    • Windows 10 was free for the first year or so, and Windows itself has gone from being the focal point of the company to being split into two separate divisions.
    • Microsoft’s premier development tool, Visual Studio, now has a Mac version, and supports the development of Android and iOS applications. Microsoft has also released Visual Studio Code, which runs on Windows, Mac and Linux. 

The new strategy appears to have been very successful, as MSFT stock is up over 200% since Nadella became CEO (among other metrics, including employee morale).  Microsoft, as of this writing, has overtaken Apple to become the most valuable company in the world (something most would have thought unthinkable a few years ago).

Meanwhile, unlike some other members of the Office family, such as Word, Excel, and PowerPoint, Access runs only on Windows.  Only people running full Windows, a diminishing proportion of the general computing market, can run our applications. 

You’ll recall that Access itself was removed from the Business (as opposed to Enterprise) editions of Office 365, but later returned because of strong customer demand. The latest attempt to “get Access on the web”, Access Web Apps, which launched with fanfare in  Office 2013, was terminated less than five years later.  Work on the Access client application has been happening recently, most notably with the reworking and expanding of data connections, and with modern charts. 


So, Whither Access?

At first glance, things don’t look promising for our favorite database application and development environment.  Looking deeper, though, there is great opportunity for Access in this cloud/mobile world.  Let’s start at looking at what Access still does uniquely well:

  • Access is a great RAD database designer. The ease of setting up tables, indexes, relations, and queries are unparalleled.  What made Access so popular at the start remains a core strength.
  • Access generates great rich-client data-driven applications. With the full richness of Win32 at its disposal, Access has powerful and performant application features like a rich set of form controls, validation, form and datasheet views, and so forth. 
  • Access is a great RAD tool for reports and charts. The ease of development and power of Access reports remain a key strength of Access.  Modern charts, introduced in Office 365 / 2019 adds to this. 
  • Access integrates very well with Windows and Windows applications, notably other Office applications. Win32 APIs are available to Access, and integration with the full Office applications, such as sending email via Outlook, exporting to Excel, or generating a Word document, is excellent.

These are the key questions. Is it possible to hold on to these things that Access developers have loved for 25 years, and be relevant in the new cloud/mobile world?  Is there any way that we can keep Access and yet be relevant on iPads or Macs, or even phones?  Or does Access go the way of the dodo bird?

Well, it’s our belief that Access can do fantastically well in the cloud/mobile world.  With a little effort, we can have our cake and eat it too. 

One of Microsoft’s key points of strategy in Azure’s success is something called the Hybrid Cloud.  Essentially, this means the best of Windows and the best of the cloud, working together.  It’s not a stretch to say that Access is one of the best things in Windows. In the coming months, we’ll take a close look at how Access can make use of the best of the cloud. 


Coming Posts

We’ll be breaking this conversation up into three sections: data in the cloud, Access application in the cloud, and extending the application in the cloud:

  • Access using a cloud database for its backend (and all the corresponding benefits)
  • Access applications running in a cloud VM (and all the corresponding benefits)
  • Extending our applications’ feature set and reach (Power BI, ASP.NET web/mobile, and so on)

Thanks for reading and stay tuned!

 

About the author

 

George Young.jpg

George first encountered Microsoft Access when using the thirty-plus floppy disk versions of Office to teach Statistics and MIS in the early 1990’s. It’s been true love ever since. George has worked as a software developer for the past twenty-five years, half of that time at Microsoft (in just about every group other than Office).  He is now an independent consultant (Dawson Butte Software) based in the Denver area, working primarily on .NET applications for public- and private-sector clients (often with Access somewhere in the mix), and actually still has a commercial site or two that is driven by an Access database sitting in the web server file system.  George is the current President of the Denver Area Access Users Group (http://www.daaug.org/), and has spoken at a variety of conferences, including Access Day in California and Colorado, the 2018 Portland Database Designer International Conference, and the 2019 Microsoft Global Azure Bootcamp in Denver, as well as for a dozen or so user groups, both domestic and international. 

 

 

 

2 Comments
Occasional Visitor

The future application of my Access/VBA skills has been on my mind for a while.  This article has my attention and I'm looking forward to what else you have to say.

Occasional Visitor

I have a small problem with access that was hoping you might be able to help with. 

 

I have a "select" query that produces perfect results. 

however, the same query if its converted to a make table query some data drops. 

additionally when connecting a pivot table from excel the same data points goes missing. 

any idea what could be happening? 

the data is only 370000 rows