In this episode, we're going to learn how to create a vbScript file that will link or relink all of our linked table in our Access "front-end" file to a "back-end" database file. See how easy it is to use your VBA style coding in a script that runs outside of Access and can be placed in a user's startup folder or a windows scheduler to run when needed, without user intervention. Let's go and relink our application front-end file!
Related Videos:
How to disable and enable the Bypass Key on your MS Access app so users cannot bypass Autoexec/Forms
https://youtu.be/DHqOZsH5u5o
Link and Relink Your Access Front-End App Using vbScript and a Table-Based Approach
https://youtu.be/kJIZ-b9idrg
How to Use vbScript to Relink Your User's MS Access Application Front-End Automatically
You are watching this video now!
Use vbScript to Deploy your Access Front End, Create Shortcuts, and Check for Updates on User Login
https://youtu.be/ar3ijaG7JtQ
How to Encrypt and Hash Passwords in MS Access
https://youtu.be/2VrFXQd7xDQ
How to Encrypt Sensitive Data in Microsoft Access
https://youtu.be/k0yYVgTH-JA
How to Kick Users out of Your MS Access Database
https://youtu.be/noKLt1mm7D4
How to Get the IP Address in Microsoft Access
https://youtu.be/WjqSbgyD6fQ
How to Get the Windows Username in MS Access
https://youtu.be/u9TRuwdT46U
How to Set Basic Startup Options on Your Microsoft Access Database
https://youtu.be/M6VxBY9mt_s
Interested in transforming your career or finding your next gig?
https://system.billzone.com/careers.html
Want my team to do a project for you? Let's get to it!
https://buy.billzone.com/smdeprojects.html
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
#vbscript #msaccess
https://youtu.be/JhYgRjkAEnA