Share a database (MDB)

 Note   The information in this topic applies only to a Microsoft Access database (.mdb).

To access the shared Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) from another computer, you must have one of following on the other computer: a local installation of Access, a network installation of Access (licensed on a per-user basis), or a run-time application.

  1. Set up a shared folder.

For information about sharing folders, use the Microsoft Windows Help Index. If the shared folder is on a network server, you might need assistance from your network administrator.

  1. Copy the Microsoft Access database to the shared folder.
  2. Make sure the Access database is set to open in shared mode, which is the default setting.


  1. On the Tools menu, click Options.
  2. On the Advanced tab, under Default open mode, click Shared.

 Note   Before you share the database, you should remove any personal information that may be stored in the file. See Remove personal information from an Access file or page for more information.

Applies to:
Access 2003