ACC2000: Programmatically Starting Client/Server Related Dialog Boxes

ID: Q230170

The information in this article applies to:

Microsoft Access 2000

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