ACC1x: Error When Opening Attached Table in Shared .MDB File 1.xLast reviewed: June 6, 1997Article ID: Q99936 |
The information in this article applies to:
SYMPTOMSWhen you attempt to open an attached table in a shared .MDB file, one of the following error messages appears:
CAUSEThe path to an attached table is hard-coded in the table's properties. For a shared .MDB file, this path is very likely invalid.
RESOLUTIONTo work around this problem, either change the path to the attached file so that it is valid, or import the data instead of attaching the table. To verify and correct the path for an attached table, use the following procedure:
MORE INFORMATIONIf the .MDB file is placed on a non-dedicated server that does not allow redirecting to itself (for example, Microsoft Windows for Workgroups), you must maintain two separate .MDB files, one to share with other workstations and one for your local computer. Maintaining two separate copies of the .MDB file is necessary because Windows for Workgroups does not allow a server to redirect to itself. For example, if the server name is SERVERNM, the SERVERNM computer cannot use the path \\SERVERNM\SHARE to access a file from its own hard disk. If the .MDB file is placed on a non-dedicated server that does allow redirecting to itself (for example, Microsoft Windows NT), you only need to maintain one .MDB file.
REFERENCESMicrosoft Access "User's Guide," version 1.0, pages 69-72
|
Additional query words: attach multiuser
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |