This can be a shared folder on a PC, a folder on a server, NAS device, … Once you’ve split your database, then you need to place the BE in a centrally accessible location. In the picture below, the BE would be located on the server (middle of the picture) and each laptop would have a copy of the FE for the user to use to access and work with the data.
(You can easily split a database DATABASE TOOLS -> Access Database (under Move Data)) Front-End (FE), the GUI if you will (queries, forms, reports, macros, VBA, …).The only time a single file Access database should be considered, and even then, would be when you create a database for the use of a single user! Otherwise, you MUST always split your database into two components: Right off the bat, Microsoft starts developers off on the wrong foot by creating a single database file. Best Practices and Troubleshooting Steps.Automatic Distribution of the Front-End.Distributing the Front-End to your Users.Preparing your Front-End for Distribution.Persistent Connection between the FE and BE.Securing/Password Protecting/Encrypting the Back-End.So, today, I thought I’d take a stab at properly covering the subject from A to Z, and everything in between. One of the most important questions we see in the forums is regarding How to setup an Microsoft Access multi-user production database.
0 kommentar(er)
