ACC2000: Programmatically Starting Client/Server Related Dialog Boxes

ID: Q230170


The information in this article applies to:

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.

Additional query words: inf


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

Last Reviewed: June 28, 1999