ACC95: Replica and Design Master Cannot Have Same Name and Path

Last reviewed: May 23, 1997
Article ID: Q138975
The information in this article applies to:
  • Microsoft Access version 7.0

SYMPTOMS

Advanced: Requires expert coding, interoperability, and multiuser skills.

If you create a replica database with the same name and location as the Design Master database, you may receive an alert message, such as the following:

   The file 'c:\msoffice\access\sample\northwind.mdb' already
   exists. Replace existing file?

This is followed by the message:

   Microsoft Access can't make a new replica at
   'c:\msoffice\access\sample\northwind.mdb1' because
   the source has the same path and filename.

The first message is misleading because a replica cannot have the same name and path as the Design Master database. However, the second message summarizes the problem correctly.

RESOLUTION

To work around this problem, type a unique name for the replica database when you create it or select a path different from the location of the Design Master database.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 7.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

  1. In Windows Explorer, make a copy of the sample database Northwind.mdb and name it Repltest.mdb.

  2. Start Microsoft Access and open the Repltest.mdb.

  3. On the Tools menu, point to Replication, and then click Create Replica.

  4. In the "This database must be closed before you can create a replica" dialog box, click Yes.

  5. In the "Microsoft Access can make a backup of your database before converting it to a Design Master" dialog box, click Yes.

  6. In the Location of New Replica box, select the same folder location as the Repltest.mdb database. In the File Name box, type Repltest.mdb and click OK. Note that you receive the following message:

          The file 'c:\msoffice\access\sample\repltest.mdb' already
          exists. Replace existing file?
    

  7. Click Yes. Note that you receive a second message:

          Microsoft Access can't make a new replica at
          'c:\msoffice\access\sample\repltest.mdb1' because
          the source has the same path and filename.
    

    Clicking Yes or No in this dialog box will take you back to the

       'Location of New Replica' dialog box.
    
    

REFERENCES

For more information about creating replicas, search on the phrase "replication," and then view "Create a replica of your database" using the Answer Wizard from the Microsoft Access for Windows 95 Help menu.


Additional query words: destination
Keywords : kberrmsg kbusage RplGen
Version : 7.0
Platform : WINDOWS
Hardware : X86
Issue type : kbbug
Resolution Type : kbworkaround


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 23, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.