When you browse to an Active Server Pages (ASP) file that was exported from Microsoft Access 97, and the file contains a large query, you may receive the following error message:

The ASP page contains a query that exceeds the 1,022 character line limit set by VBScript and you are using the Microsoft products listed at the beginning of this article.

To correct this problem, you must first open the .ASP file using Notepad or another text editor, and break the SQL string into smaller segments. For example, assume that you have the following select statement within your ASP file:

This statement should be modified as follows:

How to Determine Your Version of VBScript and ASP

To determine which version of VBScript you have, follow these steps:

1. Click the Start button, point to Find, and then click Files Or Folders.
2. In the Named box, type vbscript.dll, and then click Find Now.
3. Using the right mouse button, click the Vbscript.dll file name in the Name list, and on the shortcut menu, click Properties.
4. Click the Version tab and note the "File version" information.
   

         VBScript   DLL version   File Date   File Size
         ---------------------------------------------------
         2.0        2.0.0.1125    (varies)    252,232 bytes
   						

For additional information about versions of VBScript, please see the following article in the Microsoft Knowledge Base:

167138  (http://kbalertz.com/Feedback.aspx?kbNumber=167138/EN-US/ ) OL97: General Information About Using VBScript with Outlook



To determine which version of ASP you have, follow these steps:

1. Click the Start button, point to Find, and then click Files Or Folders.
2. In the Named box, type asp.dll, and then click Find Now.
3. Using the right mouse button, click the asp.dll file name in the Name list, and on the shortcut menu, click Properties.
4. Click the Version tab and note the "File version" information.
   

         ASP        DLL version   File Date   File Size
         ---------------------------------------------------
         1.0b       1.15.14        3/14/97    378,992
   						

Steps to Reproduce Behavior

NOTE: This section contains information about editing ASP files, and assumes that you are familiar with editing ASP files. Microsoft Access Product Support professionals do not support customization of any HTML, HTX, IDC, or ASP files.

CAUTION: Following the steps in this example will modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and perform these steps on a copy of the database.

1. Start Microsoft Access and open the sample database Northwind.mdb
2. Select the Invoices query from the Database window, and then on the Edit menu, click Copy.
3. On the Edit menu, click Paste. In the Paste As dialog box, type qryASPTest.
4. Open the qryASPTest query in Design view, and add the following fields to the query grid:
   

           Field: QuantityPerUnit
             Table: Products
             Show: Yes
   
          Field: UnitsInStock
             Table: Products
             Show: Yes
   
          Field: UnitsOnOrder
             Table: Products
             Show: Yes
   						

5. Add the following criteria to the CustomerID field:
   

           [Enter ID]
   						

6. On the Query menu, click Parameters.
7. Type the following in the Query Parameters dialog box, and then click OK.
   

           Parameter          Data Type
           ----------------------------
           [Enter ID]         Text
   						

8. Save the qryASPTest query and close it.
9. Select the qryASPTest query in the Database window, and then on the File menu click Save As/Export.
10. In the Save As dialog box, click "To an External File or Database," and then click OK.
11. In the "Save Query 'qryASPTest' In" dialog box, select Microsoft Active Server Pages (*.asp) in the Save As Type box, and type qryASPTest.asp in the File Name box. Note the folder where the files will be exported. Click Export. The Microsoft Active Server Pages Output Options dialog box appears.
12. In the Data Source Name box, enter the name of a System DSN that points to the sample database Northwind.mdb.
    
    For more information on how to define a system DSN, search the Help index for "ODBC, setting up data sources," and see the following article in the Microsoft Knowledge Base:
    
    159682  (http://kbalertz.com/Feedback.aspx?kbNumber=159682/EN-US/ ) "Data Source Name Not Found" Err Msg Opening Web Page
13. Click OK in the Enter Parameter Value dialog box that appears. Note that the ASP output creates two files: qryASPTest.html and qryASPTest.asp.
14. Copy qryASPTest.html and qryASPTest.asp to a folder on your Web Server computer where you have both Read and Execute permission. Read permission is necessary to browse the HTML file, and execute permission is necessary to run the ASP file.
15. Start Microsoft Internet Explorer or another Web browser program. Type the Uniform Resource Locator (URL) in the address box of your Web browser to view qryASPTest.html. For example, if you saved your IDC files in a folder called Test in the wwwroot folder of your Web Server, type:
    
    http://<servername>/test/qryASPTest.html (http://<servername>/test/qryASPTest.html)
    
    Note that the URL depends upon where your files are located on the Web Server.
16. Type QUEEN, and then click Run Query.

Note that you receive the error message described in the "Symptoms" section of this article.

For more information about configuring Microsoft Internet Information Server (IIS) permissions, please refer to the IIS Help Index, and see the following article in the Microsoft Knowledge Base:

160754  (http://kbalertz.com/Feedback.aspx?kbNumber=160754/EN-US/ ) Error "HTTP/1.0 403 Access Forbidden" Browsing IDC Page

For more information about the VBScript limit of 1022 characters, please see the following article(s) in the Microsoft Knowledge Base:

174634  (http://kbalertz.com/Feedback.aspx?kbNumber=174634/EN-US/ ) PRB: VBScript Compilation Error Message '800a03e9' Out of Memory