Microsoft KB Archive/163466: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
| Line 51: | Line 51: | ||
== SYMPTOMS == | == SYMPTOMS == | ||
The | The "Publish to the Web" Wizard does not allow you to type in a unique name for a file. It appends <span class="kbd userinput"> _1</span> to the end of each file that it publishes. For example, the table "Categories" is saved as "Categories_1.html" when you publish it to HTML format using the "Publish to the Web" Wizard.<br /> | ||
<br /> | <br /> | ||
If you use the | If you use the "Publish to the Web" Wizard to export two objects that have the same name, an <span class="kbd userinput"> _2</span> is appended to the end of the second file name. For example, if you click Save As HTML for the Categories table and the Categories form at the same time, two files are created, Categories_1.html and Categories_2.html. | ||
</div> | </div> | ||
| Line 60: | Line 60: | ||
== CAUSE == | == CAUSE == | ||
The | The "Publish to the Web" Wizard allows you to export multiple objects; therefore, it cannot allow you to specify custom file names. | ||
</div> | </div> | ||
| Line 71: | Line 71: | ||
# Select the object you want to publish in the Database window. | # Select the object you want to publish in the Database window. | ||
# On the File menu, click, Save As/Export. | # On the File menu, click, Save As/Export. | ||
# In the Save As dialog box, click | # In the Save As dialog box, click "To an External File or Database." Click OK. | ||
# In the Save In dialog box, select the folder where you want to save your file. | # In the Save In dialog box, select the folder where you want to save your file. | ||
# In the Save As Type box, select a Web format for your file. | # In the Save As Type box, select a Web format for your file. | ||
| Line 80: | Line 80: | ||
NOTE: You cannot simply rename your files after you export them because scripts in IDC and ASP files still refer to the original name. In addition, if links in other HTML files (such as a default home page) refer to the original name, those links will be broken if you rename the original file.<br /> | NOTE: You cannot simply rename your files after you export them because scripts in IDC and ASP files still refer to the original name. In addition, if links in other HTML files (such as a default home page) refer to the original name, those links will be broken if you rename the original file.<br /> | ||
<br /> | <br /> | ||
Note also that the | Note also that the "Publish to the Web" Wizard overwrites existing files without warning; the Save As/Export command on the File menu prompts you before overwriting existing files. | ||
</div> | </div> | ||
| Line 100: | Line 100: | ||
# Start Microsoft Access and open the sample database Northwind.mdb. | # Start Microsoft Access and open the sample database Northwind.mdb. | ||
# On the File menu, click Save As HTML. | # On the File menu, click Save As HTML. | ||
# Click Next on the opening screen of the | # Click Next on the opening screen of the "Publish to the Web" Wizard. | ||
# On the | # On the "What do you want to publish?" screen, select all of the Northwind tables. Click Finish. | ||
# When the wizard finishes creating the files, use Windows Explorer or File Manager to locate the folder where you saved the HTML files. Note that the files have the same names as the objects you selected to publish, with | # When the wizard finishes creating the files, use Windows Explorer or File Manager to locate the folder where you saved the HTML files. Note that the files have the same names as the objects you selected to publish, with "_1" appended to the end. | ||
| Line 110: | Line 110: | ||
== REFERENCES == | == REFERENCES == | ||
For more information about exporting HTML, IDC, or ASP files, search the Help Index for | For more information about exporting HTML, IDC, or ASP files, search the Help Index for "Publish to the Web Wizard" or ask the Microsoft Access 97 Office Assistant. | ||
</div> | </div> | ||
Latest revision as of 11:01, 21 July 2020
Article ID: 163466
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Access 97 Standard Edition
This article was previously published under Q163466
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
The "Publish to the Web" Wizard does not allow you to type in a unique name for a file. It appends _1 to the end of each file that it publishes. For example, the table "Categories" is saved as "Categories_1.html" when you publish it to HTML format using the "Publish to the Web" Wizard.
If you use the "Publish to the Web" Wizard to export two objects that have the same name, an _2 is appended to the end of the second file name. For example, if you click Save As HTML for the Categories table and the Categories form at the same time, two files are created, Categories_1.html and Categories_2.html.
CAUSE
The "Publish to the Web" Wizard allows you to export multiple objects; therefore, it cannot allow you to specify custom file names.
RESOLUTION
To assign a custom file name to your Web file, follow these steps:
- Select the object you want to publish in the Database window.
- On the File menu, click, Save As/Export.
- In the Save As dialog box, click "To an External File or Database." Click OK.
- In the Save In dialog box, select the folder where you want to save your file.
- In the Save As Type box, select a Web format for your file.
- In the File Name box, type the name you want to give to your Web file. Click Export to create the file.
This provides you with a custom-named file in the Web format of your choice.
NOTE: You cannot simply rename your files after you export them because scripts in IDC and ASP files still refer to the original name. In addition, if links in other HTML files (such as a default home page) refer to the original name, those links will be broken if you rename the original file.
Note also that the "Publish to the Web" Wizard overwrites existing files without warning; the Save As/Export command on the File menu prompts you before overwriting existing files.
STATUS
This behavior is by design.
MORE INFORMATION
Steps to Reproduce Behavior
- Start Microsoft Access and open the sample database Northwind.mdb.
- 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, select all of the Northwind tables. Click Finish.
- When the wizard finishes creating the files, use Windows Explorer or File Manager to locate the folder where you saved the HTML files. Note that the files have the same names as the objects you selected to publish, with "_1" appended to the end.
REFERENCES
For more information about exporting HTML, IDC, or ASP files, search the Help Index for "Publish to the Web Wizard" or ask the Microsoft Access 97 Office Assistant.
Additional query words: filename unique
Keywords: kbinterop kbprb KB163466
