Last Update: 2024 - 05 - 21
|
Techworld - Devops Bootcamp By Nana -fco-by Philipp Stiefel, originally published April 22 2020, last updated April 22 2020
Quite often one of the major problems with the migration to the 64bit-Edition of Microsoft Access is the Microsoft TreeView Control included in the Microsoft Windows Common Controls library. For a very long time this control was not available for 64bit. This text is written with the TreeView control in close focus. But all the information here also applies to the other Common Controls, like the ListView, ImageList, and ImageCombo. Prologue – (Un)Availability of the 64bit TreeViewIn the early days of 64bit Office/Access there was increased confusion about this topic because apparently Microsoft included the Common Controls in the 64bit installation, but that were the 32bit Common Controls, which did not work in 64bit applications. After years of countless support request and complaints, Microsoft finally decided to release a 64bit edition of the Microsoft Common Controls particularly for the use with Microsoft Office. This was released in the Update 1707 of July 27 2017 (Build 8326.2058). Quote of the relevant info: Office suite: Non-security updates Add 64-bit support for mscomctl.ocx, allowing users working in 64-bit versions of Office to create, edit, and open macro files containing the Common Controls. As there still is ongoing confusion on how to install and use the 64bit Edition of the Microsoft Common Controls, I decided to investigate the issues and write down my findings. No 64bit TreeView with Access 2013 (and 2010)I started my investigation with an installation of Microsoft Access 2013 64bit in Windows 8.1 (64bit). I’m very certain that the operating system is not relevant in this context and it will not matter whether this is done on Windows 7, 8 or 10. With a default installation of Microsoft Access 2013 64bit there is neither a MSCOMCTL.OCX file in C:\WINDOWS\SysWOW64\ (this is the system directory of the 32bit subsystem!) nor in C:\Windows\System32 (the default 64bit system directory). If I try to insert an ActiveX Control into an Access form there is no Microsoft TreeView Control available in the list of installed ActiveX Controls. The 64bit TreeView with Access 365 (and 2019)Then I installed the 64bit Edition of Microsoft 365 Click-to-Run (C2R). At the time of writing, I got the Version 2003 of Access 2016/365. Installing this did not make any difference regarding the MSCOMCTL.OCX file in the Windows system directories mentioned above. We must be aware of the fact that the C2R-Editions of Office are installed into a semi-virtualized environment (sandbox). For a 64bit Office installation, all files that are not immediately a part of Office will not be installed in the usual, global system directories but in the directory C:\Program Files\Microsoft Office\root\vfs (vfs = Virtual File System). The System subdirectory in the above directory now contains our desperately needed MSCOMCTL.OCX file.
After starting my newly installed Access 2016 and creating a new form, I’m immediately able to insert a TreeView Control into this form. The TreeView visually appears “normal”, displays the sample nodes and a small bit of test code I created, works also as expected, including the event handling. Techworld - Devops Bootcamp By Nana -fco-Let me know exactly what you wanted from the article or the “FCO” tag, and I’ll give a precise, useful answer. The air in the "TechWorld" server room was thick with the hum of fans and the smell of ozone. Nana Janashia, known across the digital realms as the architect of clarity, stood before a holographic console. Her mission: to transform a ragtag group of aspiring engineers into a fleet of elite DevOps warriors. "The old ways are crumbling," Nana said, her voice steady. "Manual deployments and siloed code are the ghosts of the past. Today, we build the pipeline." Phase 1: The Containerization The trainees started in the Docker shipyards. They learned to package their heavy applications into sleek, lightweight containers. "If it doesn't fit in the box, it doesn't sail," Nana warned. One student, Leo, struggled with a bloated image until Nana showed him the art of multi-stage builds—shaving gigabytes off his payload in seconds. Phase 2: The Orchestration With their containers ready, the team faced the Kubernetes nebula. It was a chaotic swirl of pods and nodes. Nana guided them through the YAML scrolls, teaching them how to command the cluster so that if one pod fell, two more would rise in its place. "Self-healing isn't magic," she smiled, "it's architecture." Phase 3: The Infinite Loop The climax came at the CI/CD bridge. The goal was a legendary feat: a "Zero-Downtime Deployment." As the trainees linked GitLab, Jenkins, and Terraform together, the pipeline began to glow. Code flowed like water, tested by automated sentries and deployed into the cloud without a single stutter in service. As the bootcamp concluded, the trainees didn't just have certificates; they had the "DevOps Mindset." They looked at the sprawling infrastructure of TechWorld and no longer saw a mess of cables—they saw a living, breathing, automated symphony. The bootcamp focuses on teaching not just specific tools, but the underlying concepts and how they integrate into a complete Software Development Life Cycle (SDLC). Self-paced video lectures, illustrated handouts, and hands-on Git projects. Students complete over 24 real-life projects to build a professional portfolio. Access to a private Discord community and technical support from senior engineers for up to two years. Certification: Graduates receive a digital certificate of completion through Curriculum & Technologies The roadmap is structured in layers, moving from infrastructure basics to advanced automation. DevOps Bootcamp | TechWorld with Nana DevOps is more than a set of tools; it’s a culture that bridges development and operations to deliver software faster, safer, and more reliably. TechWorld’s “DevOps Bootcamp by Nana — FCO” is a focused, hands-on program designed to fast-track engineers, sysadmins, and developers into production-ready DevOps practitioners. TechWorld - DevOps Bootcamp by Nana: A Comprehensive Guide In the rapidly evolving landscape of software engineering, DevOps has transitioned from a buzzword to a critical necessity for organizations aiming for agility and speed. Among the myriad of training options available, the TechWorld - DevOps Bootcamp by Nana stands out as a highly practical and respected program. Often associated with the "FCO" (Free Code Offer or Free Course Open) initiatives, this bootcamp has become a go-to resource for aspiring engineers. Here is an informative breakdown of what this bootcamp entails, who it is for, and why it has garnered such a strong reputation in the tech community. The bootcamp does not assume you know Linux. It starts with the absolute basics of the command line, file systems, and permissions. It rapidly escalates into Bash and Python scripting, teaching you how to automate repetitive tasks—a non-negotiable skill for any platform engineer. [Link to registration] – Limited seats for FCO cohort TechWorld with Nana DevOps Bootcamp is a high-end, self-paced online program designed to take learners from technical foundations to job-ready DevOps or Cloud engineering roles. It is widely recognized for its visual teaching style and comprehensive project-based curriculum, though it is significantly more expensive than alternative platforms like Udemy. TechWorld with Nana Core Curriculum & Structure The program consists of 16 modules that emphasize how different tools integrate within the Software Development Life Cycle (SDLC). TechWorld with Nana Key Modules : Linux Basics, Git, Docker, Kubernetes (including EKS), Jenkins (CI/CD), AWS, Terraform (IaC), Python Automation, Ansible, and Prometheus for monitoring. Hands-on Focus : Includes over 24 real-life projects designed to help students build a professional portfolio. TechWorld - DevOps Bootcamp By Nana -FCO- : Offers 24/7 live support from senior engineers across multiple time zones and an exclusive Discord community. : Typically recommended as a 6-month journey with 10–15 hours of study per week. TechWorld with Nana Reviews and Reputation User feedback is generally very positive regarding the teaching quality, though there is debate about the price-to-value ratio. : Reviewers on Trustpilot consistently praise Nana's "straight to the point" delivery and high-quality graphics that make complex concepts easy to grasp. Holistic Approach : Unlike modular courses that teach tools in isolation, this bootcamp focuses on how tools like Docker, Kubernetes, and Jenkins "tie together". Real-World Depth : Students highlight that the course doesn't avoid "tricky tasks," preparing them for actual on-the-job challenges. Weaknesses High Price : At approximately $1,795 - $1,895 , it is much costlier than the $15–$30 monthly subscriptions offered by competitors like or one-off $20 Udemy courses. Entry Level vs. Expert : While marketed as "Zero to Hero," some experienced engineers feel the content can stay at a high-level overview rather than providing "expert-level" depth in every tool. Who is it for? Recommended for : Career switchers or junior developers who value a highly structured, guided path and want to avoid the "tutorial hell" of disjointed free resources. Not recommended for : Self-starters on a tight budget who are comfortable piecing together documentation and cheaper specialized courses. comparison of this bootcamp against cheaper alternatives like DevOps Directive Alex sat at his desk, staring at a tangle of manual deployment scripts that felt more like a trap than a workflow. Every "push to production" was a gamble, a caffeine-fueled prayer that nothing would break. He knew there was a better way—a world of automation, scalability, and seamless pipelines—but he was stuck on the outside looking in. Then he discovered the TechWorld - DevOps Bootcamp by Nana From the first module, the fog began to lift. Nana didn't just explain tools; she bridged the gap between "code" and "infrastructure." Alex started with the fundamentals of , containerizing his messy apps into neat, portable packages. He moved on to Kubernetes , learning to orchestrate those containers like a conductor leading a symphony. Through the bootcamp's hands-on approach, he built a robust CI/CD pipeline from scratch. He watched, mesmerized, as his code was automatically tested, built, and deployed to the cloud. The "fear of the push" vanished, replaced by the quiet hum of Infrastructure as Code (IaC) using Terraform and Ansible. By the end of the program, Alex wasn't just a developer anymore; he was a DevOps engineer. He returned to his team not with more scripts, but with a philosophy of efficiency. At TechWorld, he didn't just learn how to use the cloud—he learned how to master it. tweak the tone of this story to be more professional for a LinkedIn post, or perhaps more dramatic for a promo video Mastering the Pipeline: A Deep Dive into TechWorld with Nana’s DevOps Bootcamp The DevOps Bootcamp by TechWorld with Nana is an intensive, self-paced 6-month program designed to transition tech professionals into DevOps or Cloud Engineering roles. Led by Nana Janashia, a recognized DevOps engineer and trainer, the course has gained a reputation for breaking down complex architectural concepts into digestible, hands-on lessons. Program Overview The bootcamp focuses on a "learning by doing" philosophy, requiring students to complete over 24 real-life projects to build a professional portfolio. It is structured into 16 comprehensive modules covering the full DevOps lifecycle. Format: Self-paced online video courses with 24/7 live support. Time Commitment: Recommended 10 to 15 hours per week. Let me know exactly what you wanted from Target Audience: Software developers, sysadmins, network engineers, and QA testers looking to upskill. Certification: Graduates receive a digital credential through Credly at no additional cost. The Curriculum: From 0 to Hero The curriculum is designed to be a "last stop" for mastering the essential toolset of a modern DevOps engineer. Key modules include: DevOps Bootcamp | TechWorld with Nana Welcome to TechWorld - DevOps Bootcamp By Nana - FCO! Are you ready to transform your career in tech and become a highly sought-after DevOps professional? Look no further! Our comprehensive bootcamp, led by industry expert Nana, is designed to equip you with the skills and knowledge needed to succeed in the fast-paced world of DevOps. What is DevOps? DevOps is a set of practices that combines software development (Dev) and IT operations (Ops) to improve the speed, quality, and reliability of software releases and deployments. It's a critical component of modern software development, and companies are looking for professionals who can bridge the gap between development and operations. What You'll Learn In our intensive bootcamp, you'll learn the fundamentals of DevOps, including: Hands-on Experience Our bootcamp is designed to provide you with hands-on experience through: Who Should Attend Our DevOps bootcamp is ideal for: Benefits By attending our bootcamp, you'll: Bootcamp Details Get Ready to Transform Your Career! Join our TechWorld - DevOps Bootcamp By Nana - FCO and take the first step towards a rewarding career in DevOps. Register now and get ready to: Registration Information To register for the bootcamp, please: Don't miss this opportunity to transform your career! Register now for the TechWorld - DevOps Bootcamp By Nana - FCO! DevOps is more than a set of tools; The TechWorld with Nana DevOps Bootcamp is a comprehensive, self-paced six-month program designed to transform beginners into job-ready Cloud Engineers through 24+ hands-on projects. The curriculum focuses on building a professional portfolio, covering core tools like Docker, Kubernetes, Terraform, and Jenkins, alongside career preparation support. For more details, visit TechWorld with Nana. Best DevOps Bootcamps – Forbes Advisor TechWorld: DevOps Bootcamp By Nana - FCO In today's fast-paced technological landscape, the demand for skilled professionals who can bridge the gap between development and operations teams is on the rise. DevOps, a set of practices that combines software development and IT operations, has become a crucial aspect of modern software development. To meet this demand, TechWorld, a leading online learning platform, has partnered with Nana, a renowned expert in DevOps, to offer a comprehensive DevOps Bootcamp. In this article, we will explore the world of DevOps, the benefits of the TechWorld DevOps Bootcamp, and what you can expect from this exciting program. What is DevOps? DevOps is a set of practices that aims to unify software development and IT operations. The primary goal of DevOps is to improve communication, collaboration, and integration between these two traditionally separate teams. By doing so, DevOps enables organizations to deliver high-quality software applications faster, more reliably, and with greater efficiency. In a traditional software development environment, developers focus on writing code, while operations teams focus on deploying and maintaining the infrastructure. However, this separation often leads to misunderstandings, delays, and inefficiencies. DevOps seeks to break down these silos by promoting a culture of collaboration, automation, and continuous improvement. The Benefits of DevOps The benefits of DevOps are numerous. Some of the most significant advantages include: Introducing the TechWorld DevOps Bootcamp The TechWorld DevOps Bootcamp, led by Nana, a seasoned expert in DevOps, is an intensive program designed to equip you with the skills and knowledge needed to succeed in this exciting field. This bootcamp is specifically designed for: What to Expect from the Bootcamp The TechWorld DevOps Bootcamp is a comprehensive program that covers the fundamentals of DevOps, including: FCO: A Unique Approach to Learning The TechWorld DevOps Bootcamp, led by Nana, takes a unique approach to learning, focusing on: Why Choose the TechWorld DevOps Bootcamp? The TechWorld DevOps Bootcamp offers several advantages, including: Conclusion The TechWorld DevOps Bootcamp, led by Nana, is an exciting opportunity for anyone looking to start or advance a career in DevOps. With its comprehensive curriculum, hands-on experience, and expert instruction, this bootcamp is the perfect way to gain the skills and knowledge needed to succeed in this in-demand field. Whether you're a software developer, IT operations professional, or simply interested in DevOps, this bootcamp is an excellent choice. Join the TechWorld DevOps Bootcamp today and take the first step towards a rewarding career in DevOps! Before analyzing the curriculum, one must understand the instructor. Nana Janashia is a cloud architect, senior developer advocate, and the founder of TechWorld with Nana. Unlike many technical instructors who simply read slides, Nana is renowned for her "visual storytelling" approach. She has amassed millions of followers on YouTube by breaking down complex topics (like Kubernetes or Terraform) into digestible, animated diagrams. The TechWorld - DevOps Bootcamp By Nana -FCO- translates this YouTube genius into a structured, certification-oriented, deep-dive experience. The "-FCO-" in the keyword likely denotes a specific cohort or version (Full Course Offering), indicating a complete package rather than a sample lecture. Unlike theoretical courses that focus heavily on definitions, Nana’s bootcamp is designed with a "learning by doing" philosophy. The curriculum covers the entire DevOps lifecycle, typically structured around the following pillars: The "-FCO-" tag implies a complete, hands-on experience. Here is what distinguishes this bootcamp from a simple video series: Redistribution to Access 2013, 2010 and early version of Access 2016If I try the same in old Access 2013 installation, I still cannot insert the TreeView controls, as it is still missing from the list of ActiveX Controls. Opening the database, I created with Access 2016 earlier, and then opening the form with the TreeView resulted in in the error “There is no object in this control.”. – I was expecting this due to the Office 2016 sandbox. The logical next step would be to copy the OCX file to the global System32 directory and register it there. So, I copied the MSCOMCTL.OCX file from the Office virtual files system into the C:\Windows\System32 folder. I then ran cmd.exe as Administrator and executed
C:\Windows\System32\regsvr32 /i C:\Windows\System32\MSCOMCTL.OCX
Unfortunately, this failed with the error message “… the call to DllRegisterServer failed with error code 0x8004005.” – Well, this might have happened because there are some dependencies of MSComCtl.ocx that in the Office-VFS\System folder, which I did not copy. Next, I tried to copy all the files from Office-VFS\System to a new folder and run regsvr32 for the OCX in that folder. – No luck, the error message quoted above persisted. I’ve got no clue what the problem is here. Maybe I missed a step. If you see my mistake, please let me know! Hacking the RedistributionThe normal and recommended way to register a DLL or OCX on any system is to use regsvr32.exe as I tried above. However, in the end for most ActiveX/COM controls and components it boils down to adding some keys and values to the Windows Registry. As a workaround to the dead-end with using regsvr32 to register the OCX, I started RegEdit and looked for the relevant Registry keys and values for the TreeView Control of my Office 365 C2R installation. These are usually in the HKEY_CLASSES_ROOT branch of the Registry and are below the class name (“MSComctlLib.TreeCtrl”) and the class id (=CLSID) (“C74190B6-8589-11D1-B16A-00C0F0283628”) of the control or component. As the C2R-Office is in a sandbox these values are also not in their usual registry path but sandboxed below the path HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY. I then exported these two keys with all their subkeys to.reg text files. I then edited those files and replaced their registry path with the usual base path HKEY_CLASSES_ROOT. After that I merged the edited files with the registry again. (Reminder: I previously copied the MSCOMCTL.OCX file to C:\Windows\System32\. This is the file these re-imported registry values are pointing to!) Et voilà! After merging my edited files in the registry, the Microsoft TreeView Control shows up in the list of insertable ActiveX controls in Access 2013! I also quickly tested my small code fragment from above and it worked!
You can download the reg-script I used to add the registry settings for Access 2013. However, this is intended as an example only. You should not use it to register the TreeView on your computer. Rather export these registry settings from your own installation, to make sure you get the settings matching your version of the TreeView control. 32bit/64bit compatibility?What if we need to use one and the same database application file in Access 32bit as well as Access 64bit? – If is an accdb (not compiled to accde) you can usually work with one and the same file without a problem. (If you use the Windows API, you need to make sure your API declarations are 64bit compatible.) What about the TreeView in this situation? If I create a form with a TreeView in Access 2016 64bit where the TreeView control is automatically available, I can open the very same database file with Access 32bit (tried Access 2016/365, Access 2013, and Access 2010) and it works right away. However, if I try a form with a TreeView control that was created in Access 2013 after applying the above registry hack, I get an error message in Access 32bit (again: Access 2016/365, Access 2013, and Access 2010). “The expression [AnyEvent] you entered as the event property setting produced the following error: There was an error loading an ActiveX control on one of your forms or reports.”
This usually indicates a problem with binary compatibility between different versions of a control. However, this cannot be the case here, otherwise it should not have worked with the Access-2016-created file. I guess, I must have missed something in my redistribution hack above. – I’m not really affected by this problem, so I’m not investing more time into fixing this problem. But, again, please let me know if you know the solution to the issue. The other way round, creating a form with TreeView control in Access 32bit and then using this form in Access 64bit worked without any problems in the default Access 2016/365 installation as well as in Access 2013 with the “hacked” TreeView installation. ConclusionCurrent versions of Access 2016/365 (and probably Access 2019 as well) have a fully compatible MsComCtl TreeView control, which works out of the box. However, this control is not intended for redistribution on its own, neither technically nor legally. If you need to use it with an older version of Access, you can probably work around the technical limitations using an approach like mine. But this does not solve any potential legal issues. - I’m not aware of any redistribution license for the 64bit MsComCtl.ocx. If you want to distribute an application using the MsTreeView to users which don’t have an Access version with the 64bit-TreeView, the best option is probably using the Access 365 Runtime, which is receiving updates and thus should also include the 64bit common controls. – Disclaimer: I have not tested the Access 365 Runtime yet.
I will never share your email with anyone. You can unsubscribe any time. © 1999 - 2024 by Philipp Stiefel - Privacy Policiy |