Enterprise Software

Split an Access database to increase application performance

Trim the fat and make your Access app more nimble! By splitting the database, you can keep the bulk of the memory-heavy application on the network file server, leaving the process you really need on each workstation. Mary Ann Richardson shows you how.

Access works better if the application code is stored locally and the data is stored on the network file server; Access only needs to send data over the network, not the entire application.

One of the first steps toward making an Access application ready for the enterprise is to split the application code from the actual data—that is, place the data tables on the network file server and leave a copy of the application code on each workstation. When a user splits an Access application, tables containing the data are in one MDB file, and the rest of the database objects (which make up the application) are in another MDB file. When a user makes changes to the application code, the changes upload to the file server and then download to each workstation—there is no contact with the data tables during the change process.

To split a database, follow these steps:

  1. Open the database you want to split.
  2. Go to Tool | Database Utilities | Database Splitter.
  3. Navigate to the folder where you want the database data to reside.
  4. Click the Split button.
  5. Click OK when the process is complete.

When users open the Access application at their workstation, they will see a special icon indicating that the tables link to the actual table on the file server.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox