Article ID: 225351 - View products that this article applies to.
This article was previously published under Q225351
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
When you run Microsoft Access Service Release 2 (SR-2) on Microsoft Windows NT, and you try to open a linked table that is in another Access database, you may receive the following error message:
After you click OK, you receive the following error message:
Couldn't use '<filename>'; file already in use.
Microsoft Access can't open the table in Datasheet view.
To prevent this problem, you can do one of the following:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Jet 3.51 Service Pack 2.
For additional information about Microsoft Jet 3.51 Service Pack 2, please see the following article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/172733/EN-US/ )ACC97: Updated Version of Microsoft Jet 3.5 Available for Download
Steps to Reproduce Behavior
For more information about linking tables, search the Help Index for "Linked Tables," or ask the Microsoft Access 97 Office Assistant.
For additional information about read-only databases and .ldb files, please see the following article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/136128/EN-US/ )ACC: Introduction to .LDB Files (95/97)