ACC2: Attach Tables on a CD-ROM or Write-Protected Media
ID: Q151571
|
The information in this article applies to:
SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.
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:
Couldn't lock file; SHARE.EXE hasn't been loaded
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:
Q151542 ACC: Link Tables on a CD-ROM or Write-Protected Media
(95/97)
Q88649 ACC: Opening Databases As Read-Only Causes Error Message
Q116387 ACC: "Couldn't lock file; SHARE.EXE hasn't been loaded"
Error
Q109957 ACC: Introduction to .LDB Files (1.x, 2.0)
Additional query words:
cdrom disk network
Keywords : kberrmsg kbinterop IsmIea
Version : 2.0
Platform : WINDOWS
Issue type : kbprb