ACC2000: Microsoft Access Action Query Wizard Add-in Available in Download Center (263471)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q263471
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SUMMARY

When you work with Microsoft SQL Server data from within Microsoft Access 2000, you now have two ways to establish a connection:
  • You can use the traditional method of linking the tables through the Microsoft SQL Server ODBC driver.

    -or-
  • You can establish a connection directly through a new data object that is known as a Microsoft Access project (.adp).
In an Access project, queries that perform an action, such as make-table, delete, insert/append, and update, are stored within the SQL Server database as stored procedures. Unlike traditional Access databases (.mdb files) that rely on the Microsoft Jet database engine, projects (.adp files) do not provide a graphical design grid to help you create stored procedures. Therefore, to create stored procedures, you must know the syntax of Transact-SQL (the structured query language in SQL Server). The Action Query Wizard is a simple utility, designed to load as an add-in, that simplifies the creation of stored procedures. After you create a query with the Action Query Wizard, you can either immediately run it, or you can save it as a stored procedure.

The following file is available for download from the Microsoft Download Center:

Download Action Query Wizard now

Release Date: May-24-2000

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

MORE INFORMATION

The download, Action Query Wizard.msi, contains the following files.

ActQryWiz.dllMicrosoft Access 2000 Com add-in
ActionQryWizReadme.docA word document containing information about installation, features, and restrictions for using the add-in

During the installation, these files are copied into the Windows\System or Windows\System32 folder.

NOTE: To install the Action Query Wizard, it is assumed that your computer already has a copy of Regsvr32.exe. If you encounter an error that indicates a failure during the installation, or you find that the Action Query Wizard does not appear in Microsoft Access, you must manually register the ActQryWiz.dll.

For additional information about how to install and manually register a .dll file such as ActQryWiz.dll by using Regsvr32.exe, click the article number below to view the article in the Microsoft Knowledge Base:

161983 ACC: Regsv32a.exe Available in Download Center

REFERENCES

For additional information about how to create and call stored procedures from within a Microsoft Access database that uses the Jet 4.0 database engine, click the article number below to view the article in the Microsoft Knowledge Base:

202116 ACC2000: Creating a Parameterized Jet Stored Procedure with DDL

Modification Type:MinorLast Reviewed:8/5/2004
Keywords:kbdownload kbfile kbgraphxlinkcritical kbhowto KB263471
©2004 Microsoft Corporation. All rights reserved.