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

• 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?

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

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.