Access Denied Error With IDC Files Created Using FrontPage (192933)
The information in this article applies to:
- Microsoft FrontPage 98 for Windows
This article was previously published under Q192933 SYMPTOMS
When you create an Internet Database Connector (IDC) file in FrontPage 98, use the IDC Wizard
to add your query, and then run the query in conjunction with the HyperText Extension (HTX) file,
you receive the following error:
[Access Denied]
CAUSE
This message appears when FrontPage parses the data and switches the Template line with the
SQLStatement line.
For example, a normal IDC file looks like this:
Datasource:Volcano
Template: something.htx
SQLStatement: Select * From Tablename
After parsing the data, the IDC file may look like this:
Datasource:Volcano
SQLStatement: Select * From Tablename
Template: something.htx
RESOLUTION
To fix your IDC file, follow these steps in FrontPage Explorer:
- Right-click the IDC file.
- Click Open With.
- Double-click Notepad.exe (text editor).
- Move the Template line above the SQLStatement line so that your data
looks like this:
Datasource:Volcano
Template: something.htx
SQLStateMent: Select * From Tablename
- On the File menu, click save.
(Either describes the workaround, indicates the path name, or list the revision number of the
product that resolves the issues.)
| Modification Type: | Major | Last Reviewed: | 12/1/2000 |
|---|
| Keywords: | kbprb KB192933 |
|---|
|