Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

ACC2000: Can't Create Publication After Disabling Server as Publisher


View products that this article applies to.

This article was previously published under Q223237
Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access project (.adp).

↑ Back to the top


Symptoms

After you disable your server as a publisher/distributor, you are unable to create new publications. When you try to create a new publication, Microsoft Access 2000 returns the following error messages instead of automatically re-configuring your server as a publisher and allowing you to continue:
<Machine Name> is not enabled as a publisher on distributor <Machine Name>.

To enable this Publisher, click Replication on the Tools menu, click Configure Publishing and Distribution, and select the Publishers tab.
This message is followed by:
[SQL-DMO] The name '<Machine Name>' was not found in the DistributionPublishers collection. If the name is a qualified name, use [] to separate various parts of the name, then try again.
When you try to follow the instructions in the error messages, you receive the following error message:
This database in not enabled for publication.

↑ Back to the top


Resolution

In order to re-configure your server as a publisher, you must first close and then re-open Microsoft Access.

↑ Back to the top


Status

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

↑ Back to the top


More information

Steps to Reproduce Behavior

  1. Using Microsoft Access 2000, open the NorthwindCS.ADP sample project located in the \Program Files\Microsoft Office\Office\Samples folder.
  2. On the Tools menu, point to Replication, and then click Create Publication.

    NOTE: In order to use the SQL Server Replication tools, you must have either the Microsoft Data Engine (MSDE) or Microsoft SQL Server 7.0 installed locally on your computer.
  3. In the Databases and Publications list, choose NorthwindsCS and click Create Publication.
  4. Complete the steps in the Create Publication Wizard to create a new publication that publishes the Categories table as an article.
  5. After you have successfully completed creating a publication, close the Create and Manage Publications dialog box, and then on the Tools menu, point to Replication, and then click Publisher Properties.
  6. In the Publishers and Distributor Properties dialog box, select the Publishers tab.
  7. In the Servers list, de-select your computer name as a publisher. When prompted to confirm your choice, click Yes.
  8. In the Publishers and Distributor Properties dialog box, click OK.
  9. On the Tools menu, point to Replication, and then click Create Publication. Note the error messages.

↑ Back to the top


References

For more information about configuring a server as a publisher, refer to SQL Server 7.0 Books Online, which is available for download from the following Microsoft Web site:

↑ Back to the top


Keywords: KB223237, kbclientserver, kbbug, kbdownload

↑ Back to the top

Article Info
Article ID : 223237
Revision : 3
Created on : 8/10/2004
Published on : 8/10/2004
Exists online : False
Views : 366