ACC97: Publish to the Web Wizard Fails on SQL Specific Query
ID: Q168874
|
The information in this article applies to:
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
When you use the "Publish to the Web Wizard" to create an HTML file from a
data-definition or a SQL pass-through query, the wizard fails, and you
receive the following error message:
Publish to the Web Wizard
The Command or action 'OutputTo' isn't available now.
You may be in a read-only database or an unconverted database from an
earlier version of Microsoft Access.
The type of object the action applies to isn't currently selected or
isn't in the active view.
Use only those commands and macro actions that are currently available
for this database.
CAUSE
Even though they appear in the list of queries that you can use in the
"Publish to the Web Wizard," data-definition and SQL pass-through queries
that do not return any records cannot be used in the wizard.
RESOLUTION
When you use the "Publish to the Web Wizard," only use queries that return
records.
MORE INFORMATION
Steps to Reproduce Behavior
- Open the sample database Northwind.mdb.
- Create a new query in Design view.
- Click Close in the Show Table box.
- On the Query menu, point to SQL Specific, and then click Data
Definition.
- In the Data Definition Query window, type the following SQL
statement:
CREATE TABLE MyTable (FirstName TEXT, LastName TEXT);
- Save and close the query as Query1.
- On the File menu, click Save As HTML.
- Click Next on the opening screen of the "Publish to the Web Wizard."
- On the "What do you want to publish?" screen, click the Queries tab,
click to select the Query1 check box, and then click Finish.
Note that you receive the error message mentioned in the "Symptoms"
section.
REFERENCES
For more information about the "Publish to the Web Wizard" and other
Internet features, search the Help Index for "Publish to the Web Wizard,"
or ask the Microsoft Access 97 Office Assistant.
Keywords : kbinterop IntPubWiz IntpWeb
Version : 97
Platform : WINDOWS
Issue type : kbprb