Shared Library Procedures in Microsoft Access

Do you have certain functions or subroutines that you use in lots of different databases? And every time you change one of them or make a modification or an enhancement, you have to go and then change it in 10 different database files? Well, in today's video, I'm going to teach you how to create a shared Library database where you can use the modules from it in any of your other Microsoft Access databases.

Mason from Hoffman Estates, Illinois (a Platinum Member) asks: I've got a function that I use in all of my different databases that I wrote myself called FormatMyDate. Some of the reporting my company uses requires a specific date-time format, and that's what this function does. However, they change the format once in a while, and I have to go through and modify it in 15 different database files. Is there any way I can use this one shared function in all of my databases so I don't have to keep updating it everywhere?

Members

Members will learn how to set up a shared library file with an encrypted ACCDE file. There are a few more steps involved, but if you're working with a multi-user networked Access solution, this is what you'll have to do to set up a shared library.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Intro to VBA
• Create Function

Recommended Courses

• Access Developer Courses

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, create shared library database, shared subs, shared functions, Microsoft Access tutorial, library file, shared modules, shared database files, Tools, references, missing or broken reference, project explorer, accdb, accde