0. Welcome (4:27)
Shared Library Forms, Queries, ACCDE Compilation, Automatic Builder
Shared library database system overview
1. Library Database 4 (13:33)
Return Values from Reusable Library Forms. Prompt In. Answer Out.
Creating reusable library prompt forms
Copying and customizing an Access form
Adding Yes and No response buttons
Using TempVars to store dialog responses
Closing a form after setting a response
Creating a public prompt function
Opening forms in Dialog window mode
Passing prompts with OpenArgs
Setting a label caption from OpenArgs
Returning dialog results from a library function
Handling closed dialogs with an empty response
Calling library forms from other databases
2. Questions & Feedback (10:52)
Sharing Queries, Copying Forms, and Distributing Library Databases
Exporting forms directly to a library database
Copying library forms with right-click Export
Opening library queries with public VBA routines
Query dependencies on library tables
Sharing library databases across applications
Choosing shared or local library file locations
Trusted locations for shared library folders
3. Library Database 5 (24:07)
Compiled ACCDE Library, Update References, Start ACCDE Builder
Why compile a library as an ACCDE file
Creating an ACCDE library file
Renaming the old ACCDB library file
Updating references to the ACCDE library
Creating an ACCDE Builder helper database
Removing unnecessary builder database objects
Adding a Make ACCDE File button
Building an Access command line in VBA
Using CurrentProject.FullName and Path
Finding MSAccess.exe with SysCmd
Passing source and destination file paths
Using the Shell command to launch Access
Closing the source database with Quit
4. Library Database 6 (28:42)
Build an Automatic ACCDE Compiler for Your Library
Read and validate ACCDE build command lines
Split command-line source and destination paths
Create ACCDE files with Access automation
Build a candidate ACCDE before replacement
Back up and replace the previous ACCDE file
Handle ACCDE build errors and cleanup
Restart the master database after compilation
Use a form timer to display build status messages
5. What's Next (8:33)
Microsoft Access Shared Library Database Project Summary and Next Lesson Topic Choices
Course wrap-up and preview of possible future Microsoft Access developer topics.
