Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 197589 - Last Review: June 28, 2004 - Revision: 2.0
ACC2000: Exporting SQL Specific Query to HTML Causes Error
This article was previously published under Q197589
Moderate: Requires basic macro, coding, and interoperability skills.
When you export a data definition query or a SQL pass-through query to HTML
format, you may receive the following error message:
Microsoft Access
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.
You cannot export data-definition and SQL pass-through queries that do not
return any records to HTML format.
Use only queries that return records when you want to export the results to
HTML format.
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 dialog box, type the following SQL statement:
CREATE TABLE MyTable (FirstName TEXT, LastName TEXT);
- Save and close the query as Query1.
- On the File menu, click Export.
- Type Query1 in the File name box. In the Save as type list, click HTML (*.html;*.htm). Click Save.
- Click OK.
Note that you receive the error message mentioned in the "Symptoms"
section.
For more information about exporting queries to HTML format, click
Microsoft Access Help on the
Help menu, type
export a datasheet to static HTML format in the Office Assistant or the Answer Wizard, and then click
Search to view the topic.
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate