ACC97: Action Queries Cannot Be Exported to HTML, IDC, or ASP (163443)
The information in this article applies to:
This article was previously published under Q163443 SYMPTOMS
When you try to save an action query in HTML, IDC, or ASP format, you may
receive one of the following error messages:
Query input must contain at least one table or query.
You can only save select, crosstab, or union queries to this format.
An action query cannot be used as a rowsource.
CAUSE
Action queries cannot be exported to HTML, IDC, or ASP format.
RESOLUTION
If you want to generate Internet Database Connector (IDC) files that
perform action queries, use Notepad or another text editor to write the IDC
file manually. The "More Information" section later in this article has an example of an IDC file that inserts a record into a Microsoft Access 97 database.
Instead of exporting an action query to Active Server Pages (ASP) format to
update your database, consider exporting a form to ASP format. Forms in ASP
format support adding, updating, and deleting records.
STATUS
This behavior is by design.
REFERENCES
For more information about exporting IDC files, search the Help Index for
"IDC files," or ask the Microsoft Access 97 Office Assistant. In addition,
please refer to the Microsoft Internet Information Server (IIS) Help Index.
For more information about exporting ASP files, search the Help Index for
"ASP files," or ask the Microsoft Access 97 Office Assistant. In addition,
please refer to your online ASP documentation which is installed when you
install IIS 3.0.
Modification Type: | Minor | Last Reviewed: | 1/26/2005 |
---|
Keywords: | kberrmsg kbinterop kbprb KB163443 |
---|
|