In this episode we're going to look at a powerful way to work with MS Access files without having a user open Access at all. For those of you who are learning VBA, you have been learning vbScript without knowing it! When you see how easy it is to move some of your automation out of Access and into the Windows environment, you'll start seeing how to re-do some of your more difficult sheduled tasks, to make them easier to use in various task schedulers. Related Videos: How to Use a File Dialog in MS Access to Allow Users to Pick a File or Folder https://www.youtube.com/watch?v=o8VMtHRW3w4 How to Write a Custom Text File Using MS Access VBA https://www.youtube.com/watch?v=omGFRdBfYvc How to Integrate Machine Learning into Microsoft Access Applications https://www.youtube.com/watch?v=4T6qOopbwcM How to Use Base64 in Microsoft Access https://www.youtube.com/watch?v=OOrVDjITTpM How to Use Sleep to Pause VBA in MS Access https://www.youtube.com/watch?v=rrcoA02JcwM How to Open Excel from Access Using VBA https://www.youtube.com/watch?v=A5LvSI4dIuc How to Use vbScript to Open and Work with Data in Access accdb Files - Late Binding Example You are watching this video now! For developers looking for a new role, check out and sign up: https://www.toptal.com/qKaO2b/worlds-top-talent Needing to hire technical resources for your project? Get the best: https://www.toptal.com/qKaO2b/worlds-top-talent Want to get access to premium content made just for you and have a chat with me? Find me on Patreon : https://www.patreon.com/mackenziedataengineering Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-block-rdp-98471703?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link Want to work with me 1:1? Contact me today and book your free 20 min consultation! Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering #msaccess #vbscript https://www.youtube.com/watch?v=7n80z9WkTcc