How to Use vbScript to Open and Work with Data in Access accdb Files - Late Binding Example

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
• How to Use a File Dial...
How to Write a Custom Text File Using MS Access VBA
• How to Write a Custom ...
How to Integrate Machine Learning into Microsoft Access Applications
• How to Integrate Machi...
How to Use Base64 in Microsoft Access
• How to Use Base64 in M...
How to Use Sleep to Pause VBA in MS Access
• How to Use Sleep to Pa...
How to Open Excel from Access Using VBA
• How to Open Excel from...
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:
www.toptal.com/qKaO2b/worlds-...
Needing to hire technical resources for your project? Get the best:
www.toptal.com/qKaO2b/worlds-...
Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :
/ mackenziedataengineering
Demo of my BZ RDP Cloaker:
www.patreon.com/posts/how-to-...
Want to work with me 1:1? Contact me today and book your free 20 min consultation!
Contact form you can find at www.mackenziemackenzie.com/
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksynergy.com/fs-bin/...
Got a RUclips Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy.com/seanmackenz...
#msaccess #vbscript
• How to Use vbScript to...

[@miles6875]

Sean, so this is the awesomeness you were referring to on your discord. Thank you!

[@seanmackenziedataengineering]

Yes, it is a pretty cool technique - if you work with Windows, you can do just about anything, on any version because vbScript is supported everywhere!

[@asus12351]

WHAAAAAAATT!!!! I wish I had known about this sooner man that is cool Brewster !

[@seanmackenziedataengineering]

lol! nice 👍

[@xavierbatlle1828]

Very interesting and useful for sheduled tasks! 😉

[@seanmackenziedataengineering]

Glad you think so!

[@srinivasavaradhan2312]

This is such an excellent video , Thanks Sean

[@seanmackenziedataengineering]

My pleasure!

[@bumpersmith]

Definitely would like to see some more extensive vbScript working with Access. An example might be setting up a new specified directory and copying a downloaded FE and BE database into the newly created directory. Then relinking the FE to the BE
Like I said before, GOOD topics for Access on this channel.

[@seanmackenziedataengineering]

Thanks - I'll do some more on this topic!

[@jerzykepinski]

Fantastic!

[@seanmackenziedataengineering]

Many thanks!

[@hassanrozh6579]

Really it is cool, thanks so much.

[@seanmackenziedataengineering]

Glad you like it!

[@brockmartin7316]

This is great, I am interested in the scheduling part you mention. Is this the windows task scheduler or an access based scheduler?

[@seanmackenziedataengineering]

For sure, the Windows scheduler will do the best job. I found that the best way is to call the vbs script file in the scheduler using a .bat or .cmd (or powershell) file. Not always necessary, but sometimes helps. Just a single line with the name of the script in it. I'll add that to my upcoming videos!

[@DataisKing]

I wonder if VBScript can be used for Power BI?

[@seanmackenziedataengineering]

For programming languages, I think only Python and R are supported in Power BI. M and DAX are supported for query/data transformation purposes. However, you can do a great deal of data prep in vbScript outside of PBI before the data is consumed; for example, updating a table with new figures just before PBI auto-refreshes the published version of a report.

[@SHCSBaker]

Good stuff!!! Could vbScript be used to check for updated FE?

[@seanmackenziedataengineering]

Absolutely! And to update it with a file from the network or FTP if necessary

[@xavierbatlle1828]

Unfortunately vbs has been deprecated.

[@seanmackenziedataengineering]

Thanks for sharing! What do you think about that?

[@xavierbatlle1828]

@@seanmackenziedataengineering To tell you the truth, I use vbscript and powershell and it's not a big issue vbscript deprecation. Furthermore we can use it for years before it dissapears.