Introduction
  • Introduction and a Quick Demo
Using Front and Backend Databases
  • NOTE on downloadable database
  • How Does Access Share Data?
  • Creating Front Ends and Back Ends
  • Splitting a Database Manually
  • Setting up the Backend on the Network
  • Setup Multiple Front Ends
How to Check for Front End Updates
  • Make the Front End Check for Updates
  • Create an Update Test Subroutine
  • Finish the Update Test Subroutine
  • Create the Autoexec Macro and Test the System
How to Do Front End Updates
  • Create the Update database
  • Start Building the Update Function
  • Finish Building the Update Function
  • Create the Autoexec Macro and Test the Update Database
  • Setup and Test Update on a Network Computer
Setup Your Production Environment
  • Build the Data Table List
  • Build the DelTbl Subroutine
  • Build the Remove Links Function
  • Create the Remove Links Macro and Test the Entire Update Process
Change Share Settings and Share a Folder
  • Setup Your Workgroup Name
  • Change the Default Sharing Settings
  • Setup a Shared Folder and Test From Another Computer
Using Access RUNTIME
  • Explanation of What Access Runtime Is and How to Get the Correct Version
  • Installing Access RUNTIME
  • Testing Access RUNTIME
Using Access ACCDE Compiled Databases
  • Working with Access ACCDE Databases
  • Modifying the Update Database to Use an ACCDE Database
Review and Conclusion
  • A Review of What We've Learned
  • Bonus Lecture - Learn Even More!