ACC97: Can't Link to Tables on Read-Only Media After SR-2 Update AppliedID: Q151542
|
Novice: Requires knowledge of the user interface on single-user computers.
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
The database file's read-only attribute is set to False.
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.
The symptoms described in this article occur only when linking a
Microsoft Access version 2.0 database.
In Microsoft Access 7.0 and 97, you can link a table in a version 7.0
or 97 database that resides on a CD-ROM or write-protected diskette
without having to set the read-only attribute of the .mdb. However, it is
recommended that you set the read-only attribute of the .mdb file. If you
do not set the read-only attribute of the .mdb file, the linked table will
appear to be updatable. That is, when viewing the linked table in Datasheet
view, you see a blank record at the bottom of the table, indicating that
the table is updatable. However, if you try to make changes to the
data, you may receive the error, "Couldn't open file," and any changes you
make are not saved.
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:
Q136128 ACC: Introduction to .LDB Files (95/97)
Additional query words: cdrom prb
Keywords : kberrmsg kbinterop kbdta IsmIea
Version : WINDOWS:7.0,97
Platform : WINDOWS
Issue type : kbprb
Last Reviewed: April 22, 1999