How to Split Your Access Database

This video will show you how to split your database into two files. One file will contain only your data, and the other will contain all your forms, reports, queries, and code. First, if any members of your team are using your database, ask them to close it. Once everyone is out, log into your cloud desktop and go to the folder where your database is. It's probably in the Shared Folder on the C drive. Open your database. Then click on database tools and then click on the access database icon. This will open the database splitter. Click the split database button. Then choose where your backend file should be created, that's the file that will hold your data. Click the split button when you're ready. You will see the progress in the bottom right. Then, a success message will appear when finished. Now your database is split. You should now see two files. One with an "_be" after the database name, this one holds your data. The other file will only have the database name, it contains all your forms, reports, queries, and code.