Split Your Database
By Richard Rost

7 months ago

How and Why to Split Your Microsoft Access Database

In this video, we'll talk about what splitting your database means, the benefits and drawbacks, and I'll show you how to do it.

Junior from Baton Rouge LA (a Gold Member) asks: I've heard a lot about the benefits of splitting my Access database. Can you tell me what this is all about?

Members

I'll show you how to move or rename your backend file, use the linked table manager, create multiple back end files, and manually create links to tables.

Extended Cut Video - Silver

Silver Members and up get access to an Extended Cut of this video. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to contact me so I can set up your account here on my web site. If you're not a member, Join Today!

Links

Access Updater: https://599cd.com/XPBW6
Split Database Seminar: https://599cd.com/XU6JU
Security Seminar: https://599cd.com/SplitSem
Split & ACCDE Files: https://599cd.com/XJ9V4
Search Form: https://youtu.be/HSnHGQeX9so
Compact & Repair: https://599cd.com/1331
Simple Security: https://599cd.com/SimpleSecurity
Database Password: https://599cd.com/DatabasePassword

Other Articles

https://www.techrepublic.com/blog/10-things/10-plus-reasons-to-split-an-access-database
https://support.microsoft.com/en-us/office/split-an-access-database-3015ad18-a3a1-4e9c-a7f3-51b1d73498cc
https://www.yourofficeanywhere.co.uk/info-hub/split-an-access-database/
http://www.databasedev.co.uk/split_a_database.html

Learn More

FREE Access Beginner Level 1
Access Level 2 for $1.00

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?

Questions?

Please feel free to post your questions or comments below or submit them via the TechHelp page.

Split Database Info Upload Images Link
Richard Rost
4 months ago

OVERVIEW:
Splitting your database is dividing it into two or more files. One file, called the Front End, contains your forms, reports, queries, macros, and modules. The other, called the Back End, contains just your tables. Splitting your database makes it: Read More...

Relinking Tables Upload Images Link
Elaine Heltman
7 months ago

Hi Richard. I have the admin copy of the split database on my desktop, with the backend and encrypted frontend on the server. I'll be distributing the encrypted frontend to users. After I make changes to the admin copy, I'm having issues relinking the new encrypted frontend (SavedAs from the admin desktop copy to the server) to the backend on the server folder. I do not receive the right-hand options to relink, etc., only to refresh. What am I missing in this process? Thank you!

Richard Rost
7 months ago

You can't make that kind of a change in the encrypted ACCDE front-end. You need to relink the tables in YOUR ACCDB then make a new ACCDE file.

Elaine Heltman
7 months ago

So, if I understand correctly, I relink the frontend admin desktop version with the Server BE, then make the encrypted ACCDE file savedAs to the server?

Show 7 More Replies...

Richard Rost
7 months ago

You shouldn't really have to RELINK anything unless you MOVE the backend database. When you split the database, specify your SHARED SERVER FOLDER as the location for the backend tables. Once that's done, you can change your frontend all you want. Make a new ACCDE and the linked table references will stay the same.

Elaine Heltman
6 months ago

I'm having problems again with the double-clk DoCmd.openform code working in ACCDE files. The link address is correct, I double check it, and I've also tried linking using the IP address for the server. The code works flawlessly on the ACCDB file, regardless of its location - server folder or desktop. Thanks again!

Richard Rost
6 months ago

Interesting. What are you trying to open? Does it work on ANY system or is it a machine thing?

Elaine Heltman
6 months ago

From a form, I'm trying to open another form by double-clicking a selection in a combo box. The ACCDE file does not work on any system. I've tested with both the FE and BE on my desktop; linking FE on Desktop to BE on the server (via VPN); and from a Citrix server (not via VPN). Thanks!

Richard Rost
6 months ago

Can you MsgBox something from the same event? Do other events work?

Elaine Heltman
6 months ago

Good call. Looks like it's only VBA code that's not running. Certain forms do not open to a blank record, via DoCmd.GoToRecord , , acNewRec, as well as the many DoCmd.OpenForm codes I have in most forms. But, a MsgBox that runs from a Command button that prints a report of a file, does work.

Richard Rost
6 months ago

Trust issues? Are you running the database from a Trusted Folder?