Microsoft KB Archive/324666

= You receive a &quot;You are trying to open a read-only database&quot; error message when you open a database that was created in an earlier version of Access in Access 2002, Access 2003 or Access 2007 =

Article ID: 324666

Article Last Modified on 3/26/2007

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q324666



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.accdb and .mdb).



SYMPTOMS
In Microsoft Access 2002, in Microsoft Office Access 2003, and in Microsoft Office Access 2007, if you move a database file that was created in earlier versions of Microsoft Access from one computer to another computer, and you then try to open the database on the other computer, you receive the following message:

You are trying to open a read-only database.

The first time you open an earlier version database, you must be able to write changes to the database.


 * The database file's read-only attribute may be set; clear this attribute.


 * You may have chosen the Open Read Only command in the Open dialog box. Don't choose this command the first time you open the database.


 * Your license to use this application may have expired.

Note Microsoft Office XP has built-in functionality that allows you to get more information about difficult-to-troubleshoot alerts or error messages. If you want to turn on this functionality for this and other error messages in Microsoft Office XP, download the&quot;Office XP add-in: extended alerts button&quot; from the following Microsoft Office Update Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=8FBEE1D3-C5BB-4A36-A2F7-DC63DE2A818C&displaylang=en

NOTE: If you reached this article by clicking Web Info in an error message, you already have Customizable Alerts turned on.



CAUSE
The Read-only attribute of the file may be set. This occurs automatically if you use a compact disc-recordable (CD-R) or a compact disc-rewritable (CD-RW) to move the file.



RESOLUTION
You must reset the Read-only attribute of all Access files, such as .mdb and .mdw, that you move by using a CD-R or a CD-RW. To do so, follow these steps:
 * 1) On the desktop, double-click My Computer.
 * 2) Locate the Microsoft Access database that you moved.
 * 3) Right-click the database name, and then click Properties.
 * 4) In the Properties dialog box, clear the Read-only check box under Attributes.
 * 5) Click OK to apply the change.
 * 6) Open your database in Access.

Note that you no longer receive the message that is mentioned in the &quot;Symptoms&quot; section of this article.



MORE INFORMATION
This behavior may also occur if you use a CD-R or a CD-RW to distribute a file with user-level security and transfer a workgroup information file (.mdw) to the destination computer. If you experience this behavior, follow the steps in the &quot;Resolution&quot; section to clear the Read-only attribute for the accompanying .mdw file.

Additional query words: prb error ACC2002 reviewdocid ACC2007

Keywords: kbopenfile kberrmsg kbprb ocsso KB324666

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.