Microsoft Access 2016: Split Database to Frontend and Backend

Microsoft Access 2016 training video on how to split your Access database into a frontend which includes: Forms, Reports and Queries and the backend holds the data in Tables.
All 131 of my Access 2016 training videos contain everything you need to help pass the Microsoft Access 2016 (77-730) exam and become certified!
ONLINE TRAINING: HD Videos, Quizzes, Exercises, Instructor’s Notes & Certificate of Completion!
www.DreamForce.us
SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
th-cam.com/users/subscription_c...
LET'S CONNECT!
-- / kirt-kershaw-33874410

[@garycurtis]

Excellent video, thank you so much. Question, after splitting should the relationships be created on the front or backend? I see they migrated to the backend, but do I need them in the front end too?

[@skiwam]

thanks alot sir

[@alfredzkhanlakibul8494]

nice this is what im looking

[@SteveMartinUSA]

I want to be able to modify the forms, reports, queries, and even tables independent of the production version that people are using. What is the preferred way for an MS Access developer to prepare the next version of the application while users are accessing the current production version? How could you migrate the data to the new version?

[@user-bg6nv3cb5p]

Hi Kirt, can you advice, when i copy the file and try to open in new computer but not work

[@SteveMartinUSA]

What's a Switchboard? This example uses under 2MB, but in a larger split it would make sense to compact to reduce the size of the front end files.

[@venkatyalamati3285]

Thanks for the tutorial sir.. I am having one problem with my front end file. After splitting, if I change the location or name of back-end file, the front end file is not opening. Even with holding shift-key, the access application simply opening to it's default screen asking to create a new database but my front end objects not visible... Plz tell me the solution for this

[@Unknown-wz6ly]

When i change the back-end database location.i couldn't open front-end database and access shows only home screen...

[@brandoncarraway1391]

So I split the DB and placed the _be in a network drive - how do I give each user their own front-end? Do I give them a copy of the original DB prior to splitting?

[@nimratalat1411]

same question

[@Bcarr122391]

fungus dabogeyman thank you! I’ve actually gotten pretty advanced with Access since this question, and found the beauty of using SharePoint for the backend data; we experience an issue where our network server would quickly disconnect and reconnect from the network, causing a data disconnect, forcing us to close and reopen the database 🤦🏼‍♂️. Share point fixed this.

[@bessieammons4106]

After database can you still add a table?

[@quakerboats9840]

Where is the next video?

[@davsAlmanac]

I am trying to figure a way that I could display on my web site from a Access database or SQL I want know anyone knows how