ACC97: Cannot Link to Tables on Read-Only Media After SR-2 Update Applied (151542)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q151542 Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
When you try to link a table that is located on a read-only drive, a
write-protected diskette, or a CD-ROM in Microsoft Access, you may receive
the following error message:
Couldn't lock file
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. Normally, the .ldb files are deleted when the
last user closes the mdb.
Steps to Set the Read-Only Attribute
In order to set the read-only attribute, the file must be located on a
read/write drive.
- Start Windows Explorer and select your .mdb file.
- On the File menu, click Properties.
- If the Read-Only check box is not selected, click the check box
to set the file to Read-Only.
REFERENCES
For more information about linking tables, search the Help Index for
"Linked Tables," or ask the Microsoft Access 97 Office Assistant.
For more information about read-only databases and .ldb files, please see
the following article in the Microsoft Knowledge Base:
136128 ACC: Introduction to .LDB Files (95/97)
Modification Type: | Major | Last Reviewed: | 10/31/2003 |
---|
Keywords: | kberrmsg kbfix kbinterop kbprb KB151542 |
---|
|