ACC2000: Programmatically Starting Client/Server Related Dialog Boxes (230170)


The information in this article applies to:

  • Microsoft Access 2000
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

REFERENCES

For more information about command bars, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type CommandBars property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:KbClientServer kbhowto KB230170
©2004 Microsoft Corporation. All rights reserved.