Home   |   Asp.Net 2.0   |   .Net Framework 2.0   |   IIS 6.0   |   Sql Server 2005   |   Visual Basic 2005   |   c# 2005   |   VS 2005   |   Visual Source Safe 2005

MS Dynamics CRM 3.0

SharePoint Portal Server 2003
SharePoint Server 2007
Dynamics NAV
Dynamics CRM
SharePoint Designer 2007
SharePoint Portal Server 2001
Windows SharePoint Services
Windows SharePoint Services 3.0
Project Server 2003
Project Server 2007
Dynamics – Point of Sale
Dynamics AX
Dynamics GP
Dynamics Retail Management System (RMS)
Dynamics SL
SQL Server 2000
Visual Basic .NET 2003
Visual C# .NET 2003
Visual C++ .NET 2003
Visual C++ 2005
Visual SourceSafe 6.0
Windows Server 2003
Windows Server 2003
Outlook 2003
ADO.NET 1.1
ASP.NET 1.0
Visual Studio Team Foundation Server
Visual Studio 2005 Team Edition
Windows Internet Explorer 7
BizTalk Server 2000
BizTalk Server 2002
BizTalk Server 2004
BizTalk Server 2006
Visual Studio 6.0
Access 2000
Access 2002
Access 2003
Access 2007
Access 97
Collaboration Data Objects 2.0
Commerce Server 2002
Content Management Server 2001
Commerce Server 2007
Content Management Server 2002
Data Access Components 2.7
Data Access Components 2.8
DirectX 9.0b
Office Small Business Accounting 2006
Accounting 2007
ActiveSync 4.1
Class Server 2.0
Groove 2007
Windows Vista
Outlook 2007
OneNote 2003
OneNote 2007
Office X for Mac
Zune software
Zune Live
Zoo Tycoon 2
Flight Simulator 2002
Dungeon Siege II

Cervo Technologies
The Right Source to Outsource

Oracle Database FAQS

Sharepoint Portal Server KB

Outlook 2007 Knowledge Base Articles

Access 2000 Knowledge Base Articles

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...


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.

CAUSE

You cannot export data-definition and SQL pass-through queries that do not return any records to HTML format.

RESOLUTION

Use only queries that return records when you want to export the results to HTML format.

MORE INFORMATION

Steps to Reproduce Behavior

1.Open the sample database Northwind.mdb.
2.Create a new query in Design view.
3.Click Close in the Show Table box.
4.On the Query menu, point to SQL Specific, and then click Data Definition.
5.In the Data Definition Query dialog box, type the following SQL statement:
CREATE TABLE MyTable (FirstName TEXT, LastName TEXT);
6.Save and close the query as Query1.
7.On the File menu, click Export.
8.Type Query1 in the File name box. In the Save as type list, click HTML (*.html;*.htm). Click Save.
9.Click OK.

Note that you receive the error message mentioned in the "Symptoms" section.

REFERENCES

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

Keywords: 
kberrmsg kbprb KB197589

Copyright © 2004 - 2007 Gridview.org, Inc. All rights reserved. Powered by Smart Web Content Management System