Microsoft Access 2016: Split Database to Frontend and Backend

[@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?

[@bessieammons4106]

After database can you still add a table?

[@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.

[@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?

[@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.

[@alfredzkhanlakibul8494]

nice this is what im looking

[@เกษตรกุ้มตนเอง]

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

[@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...

[@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

[@skiwam]

thanks alot sir