Article ID: 151571
Article Last Modified on 6/25/2002
APPLIES TO
- Microsoft Access 2.0 Standard Edition
This article was previously published under Q151571
Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
When you try to attach a table from a database on a read-only drive, a write protected diskette, or a CD-ROM in Microsoft Access version 2.0, you may receive the following error message:
CAUSE
The database file's read-only attribute is set to False.
RESOLUTION
Set the read-only attribute of the database file (.mdb) before copying the file to the CD-ROM or diskette. Also, do not include the database's .ldb file. For example, if your database is named Myapp.mdb, do not include Myapp.ldb on the CD-ROM or diskette. Include only Myapp.mdb on the CD-ROM or diskette.
Steps to Set the Read-Only Attribute
- Start File Manager.
- Locate and then select the .mdb file.
- From the File menu, choose Properties.
- If the Read-only check box is not checked, click to select the check box to set the file to Read-only.
MORE INFORMATION
Steps to Reproduce Behavior
- Start Microsoft Access version 2.0.
- Create a new database and add a table. Save the database, and then copy it to a diskette. Make sure the .ldb file is not on the diskette with the .mdb file.
- Set the write-protection tab on the diskette.
- Start Microsoft Access and open the sample database Northwind.mdb
- Click Attach Table on the File menu. Select Microsoft Access and click OK.
- Select the database you just created. Note that you receive the error message mentioned in the "Symptoms" section.
NOTE: The symptoms described above occurs only when attaching or linking to a Microsoft Access version 2.0 database.
REFERENCES
For more information about read-only databases and .ldb files, please see the following articles in the Microsoft Knowledge Base:
151542 ACC: Link Tables on a CD-ROM or Write-Protected Media (95/97)
88649 ACC: Opening Databases As Read-Only Causes Error Message
116387 ACC: "Couldn't lock file; SHARE.EXE hasn't been loaded" Error
109957 ACC: Introduction to .LDB Files (1.x, 2.0)
Additional query words: cdrom disk network
Keywords: kberrmsg kbinterop kbprb KB151571