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

• Microsoft Access 2000

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.

[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.

This database in not enabled for publication.

RESOLUTION

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

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

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.

REFERENCES

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

http://support.microsoft.com/download/support/mslfiles/sqlbol.exe

Additional query words: pra

Keywords : kbdta AccessCS
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug