Microsoft KB Archive/230170

= ACC2000: Programmatically Starting Client/Server Related Dialog Boxes =

Article ID: 230170

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q230170



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

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



SUMMARY
In a Microsoft Access 2000 project, you can administer SQL Server replication, SQL Server security, and back up your SQL Server database through the user interface. This article discusses how to programmatically start the dialog boxes you need to carry out this work.



MORE INFORMATION
Use the CommandBars collection of the Application object to select and start any dialog boxes that you want.

To start the SQL Server Replication tools from an Access project, use the following sample code:

Application.CommandBars("Tools").Controls.Item(9).Controls(5).Execute To open the SQL Server Security tools, use the following sample code:

Application.CommandBars("Tools").Controls.Item(8).Controls(1).Execute To prompt the user to backup a SQL Server or MSDE database, use the following sample code: Application.CommandBars("Tools").Controls.Item(7).Controls(3).Execute

