Quick Guide to Splitting an Access Database
If you are going to make your Access database available to many users who will access it over a network, it is advisable to split the main MDB file into two files. One is the back-end that will contain all the data tables and records and the other, the front-end that will contain other database objects such as forms, queries and reports. The front-end can be distributed to all the users by installing it on each workstation while the back-end is stored securely in one place on a server and ... Read More »