Microsoft Access - Database Splitting and Persistent Connections

How-To guide on splitting a Microsoft Access database (both manually or using the ribbon command) as well as how to setup a Persistent Connection for best performance.
Table of Contents:
00:13 - Introduction
00:34 - Why You Should Split a Database
06:24 - Splitting a Database Using the Command
08:26 - Importance of Encryption!
08:55 - Encrypting a Database
09:25 - Open Database Exclusively
11:48 - Manually Splitting a Database
13:30 - Persistent Connections
13:58 - Why Use a Persistent Connection
17:08 - How-To Create a Persistent Connection
My Article and Sample Database on the Subject:
www.devhut.net...
www.devhut.net...
My Links:
www.cardaconsu...
www.devhut.net/

[@hassanrozh6579]

Thanks alot for this article, I got it.

[@DanielPineault]

Great!

[@ksrinivas1729]

Thanks for the video... How to give access to multiple users and each user has to view only some section in the DB depending on the role.. example preparer and reviewer..

[@DanielPineault]

You need to build a user table, a permissions table and then use the Form Open/Report Open events to check the current user against the permissions and make the necessary adjustment or cancel the open altogether if they do not have the necessary right to the object.

[@jim27105]

Can you provide more information about the relinking routine mentioned briefly in the vba function?

[@DanielPineault]

There are a number of such routines depending on your needs, such as:
www.devhut.net/ms-access-relink-tables/
www.theaccessweb.com/tables/tbl0009.htm
dfenton.com/DFA/download/Access/Reconnect.html
www.jstreettech.com/downloads.aspx

[@iMMYBroBiz]

is not it better you use word database with only data file and use word Management systems to refer all the front end or data accessing objects , it sounds confusing when u use word database for database and front end tools or objects..together.. thanks..
because in 90s we always used combine term "Database Management Systems.." in which Database is files carrying user data and Management systems are the tools to access that Data...

[@DanielPineault]

But they're both Access database files, there's no distinction in what they can house within them.
This is why we use the terms: back-end and front-end, to differentiate the file housing the tables and relationships from the file housing the GUI components.
This is also inline with other technologies (I'm thinking of web development) that refer to back-end development vs front-end development.
Also don't forget that all files actually have a multitude of system tables that make everything function. So they are all RDMS.