Split a Database into Front-End and Back-End

To create a Seprate Front-end copy for every user and one backend copy that is shared on network and is used by multiple users

  1. Go to the database Tools tab
  2. In Move Data group you will find button for Access Database
  3. split the database

Then link the tables that are stored as backend to front end.

  1. Go to the External Data tab
  2. In “Import and LInk” group you will find button for “Linked Table Manager”
  3. Select all the tables and press ok