ACC2000: "Path/File Access" Error When You Use the Visual Basic Editor to Insert a Module into a Replica (225942)

Microsoft Access 2000

This article was previously published under Q225942

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

If you use the Visual Basic Editor to insert a module into a replica, you may receive the following error message:

Path/File Access Error

You cannot insert a module into a replica. You can insert a module only into the Design Master. The error message does not clearly explain this.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Create a new, blank database.
On the Tools menu, click Replication, and then click Create Replica.
When prompted to close the database, click Yes.
When prompted to make a backup copy, click No.

IMPORTANT: Because this is a test database, clicking No is okay in this case. For a production database, however, you should always create a back up copy before proceeding by clicking Yes.
Accept the default file name, and then click OK.
Click OK when informed that the database has been converted to a replica.
Close the Design Master, and then open the replica.
Press ALT+F11 to start the Visual Basic Editor.
On the Insert menu, click Module. Note that you receive the error message mentioned in the "Symptoms" section.

Modification Type:

Minor

Last Reviewed:

7/16/2004

Keywords:

kbbug kberrmsg kbpending KB225942