Making an Access database or project read-only

Applies to
Microsoft Office Access 2003
Microsoft Access 2002

Making an Access database or project read-only means that you can view the database objects, but you cannot make changes to them. There are three basic approaches to making an Access database or project read-only:

  • Open the Access database or project in read-only mode.

This approach is a good way to prevent accidental changes. You can instruct users to open an Access database or project in read-only mode, but this does not guarantee all users will open the data file in read-only mode.

  • Make the Access database file (.mdb) or Access project file (.adp) read-only using Microsoft Windows® Explorer.

This approach is more effective, but can be compromised either accidentally or intentionally, if another user changes the file protection settings.

  • Help protect the database and database objects.

This approach employs innovative security measures to help provide read-only access to some or all database objects, but requires securing the Access database or project and its objects.

Combining all three approaches helps protect safety while ensuring read-only access.

ShowOpen the Access database or Access project in read-only mode

  1. On the File menu, click Open.
  2. Click a shortcut in the left side of the Open dialog box, or in the Look in box, and then click the drive or folder that contains the Access database or Access project that you want to open.
  3. In the folder list, double-click folders until you open the folder that contains the database.
  4. To open the database in read-only mode, click the arrow next to the Open button, and then click Open Read-Only.

 Notes 

  • You can open an Access project only in exclusive mode. If you attempt to open an Access project while another user already has it open, Access prompts you to open a read-only copy of the file.
  • An Access project only contains forms, reports, pointers to data access pages, and modules. Tables, queries, and database diagrams are contained in the Microsoft SQL Server™ database or database engine that the Access project is connected to. Making an access project file read-only helps protect only the database objects in the project file, not in the underlying database.

ShowMake the Access database or Access project read-only using Windows Explorer

In Windows Explorer, right-click the Access database file (.mdb) or Access project file (.adp), and then select Properties. In the Properties dialog box, select the Read-only check box.

 Note   This will make the file read-only, preventing anyone from making changes to the database objects in the file. However, be aware of the following:

  • If the Access database or Access project contains data access pages, only the pointers to the underlying HTML files are made read-only. A user could still make changes to the underlying HTML files through any HTML-based editor, such as Microsoft FrontPage®, Microsoft Word, or even Notepad. Therefore, you should also make each page's underlying HTML file read-only as well by using Windows Explorer. To help protect the data accessed by the page, you must either employ security measures for the database that the page is connected to (see the following two sections) or configure Microsoft Internet Explorer security settings to prevent unauthorized access. For more information on Internet Explorer security, see Help in your Internet Explorer program.
  • An Access project only contains forms, reports, pointers to data access pages, and modules. Tables, queries, and database diagrams are contained in the SQL Server database or database engine that the Access project is connected to. Making an access project file read-only helps protect only the objects in the file, not in the database.

ShowHelp protect the database objects in an Access database

To make all objects in an Access database read-only, you can apply user-level security to the database objects. Although setting up user-level security on most databases can be a daunting task, the User-Level Security Wizard makes it easy to quickly help protect your access database in a one-step process. Furthermore, by implementing common security schemes, the User-Level Security Wizard minimizes and may even eliminate the need to use the Security command from the Tools menu.

  • To start the User-Level Security Wizard, point to Security on the Tools menu, and then click User-Level Security Wizard.

This could be due to the fact that Access is running in sandbox mode but Microsoft Jet 4.0 SP8 or later is not installed on your computer. Jet 4.0 SP8 or later is required for Access to be fully functional when sandbox mode is enabled.

For more information about installing the Jet upgrade, see the Office Online article About Microsoft Jet 4.0 SP8 or later.

For more information about sandbox mode, see the Office Online article About Microsoft Jet Expression Service sandbox mode.

ShowHelp protect the SQL Server database objects (tables, queries, and database diagrams) of an Access project

To help protect objects in a SQL Server database, you can either use Transact-SQL, SQL Server Enterprise Manager, or the Create Login Wizard. Using the wizard, you can choose the authentication mode (Windows or Mixed), add a login, add a user to a fixed server role, and grant access to a database. For more information on SQL Server security, Transact-SQL, the Enterprise Manager, and the Create Login Wizard, see the SQL Server documentation .

 
 
Applies to:
Access 2003