O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Setting Up Exclusive Use

You can't set a password for a database (see the following section) if the database is open in Shared mode. Shared mode lets more than one person work on a database at once on a network.

By default, databases are opened in Shared mode. You can override this, and open a database in Exclusive mode, by selecting the Exclusive check box in the Open dialog box when you open the file.

If you want to set the default to Exclusive mode for all databases you open, follow these steps:

  1. Select Tools Options. The Options dialog box appears.

  2. Click the Advanced tab.

  3. In the Default Open Mode area, click Exclusive.

  4. Click OK.

Why Isn't It Exclusive?

If you are reopening your database after you've set the default for Exclusive (see the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required