Open an Access data file on a network by using a UNC address

You might want to open a Microsoft Access data file on a network share by using a UNC path, instead of using the drive letter of a mapped network drive in Microsoft Windows Explorer. A drive letter can vary from one computer to another or may not always be defined, whereas a UNC path is a reliable and consistent way for Access to locate the Access data file.

  1. On the File menu, click Open .
  2. In the File name box, type the UNC address for the network share you want, and then press ENTER.

    For example, type \\Computer1\Files to open an Access data file on the Files share of the Computer1 server.

  3. In the folder list, locate and open the Access data file you want.

Tip

To open an Access data file on a network share you've recently opened by using a UNC address, click the arrow next to the File name box within the Open dialog box, and then click the UNC connection.