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

ID: Q138975

The information in this article applies to:

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

Last Reviewed: May 24, 1997