FrontPage 2000 Database Resource Center

FrontPage 2000 offers a wider array of built-in database functionality than earlier versions of FrontPage. With the new database features, you can save information submitted by web users, or you can create customized queries by using information that is contained in a database.

One of the best places to start learning FrontPage database programming is with the ASP Web Wizard 2000 for Databases. To obtain this wizard, please see the Microsoft Knowledge Base article Q206019 - FP2000: ASP Web Wizard 2000 for Databases Available for Download.

Database Queries

The following Microsoft Knowledge Base articles contain information about specialized database queries in FrontPage:

• Q205231 - FP2000: How to Search Using LIKE In SQL Statement For ASP
• Q205980 - FP2000: How to Return a List of Records as Hyperlinks Using ASP
• Q216285 - FP2000: How to Display a Picture Using a Microsoft Access Database
• Q235554 - FP2000: How to Filter a Database Query Using a List
• Q240090 - FP2000: How to Update Information in a Microsoft Access Database Using FrontPage 2000 and ASP
• Q240200 - FP2000: How to Delete a Record from Microsoft Access 2000
• Q244968 - FP2000: How to Add an All Values Item to a Database Query

Databases and Connectivity

The following Microsoft Knowledge Base articles discuss the general use of FrontPage with databases:

• Q199365 - FP2000: Installation of ASP.EXE May Interfere With Database Connectivity in Office 2000
• Q229286 - FP2000: Cannot Connect to SQL Database on Windows NT Server Computer with IIS
• Q232645 - FP2000: Configuration Settings to Assist in Securing Database Information on a Web Server
• Q233018 - FP2000: Enabling Database Features Without the Server Extensions
• Q233406 - FP2000: FrontPage 2000 Creates Access 2000 Database Files
• Q243842 - FP2000: How to Create Data Access Page Linked to Access Database in FrontPage Web

Errors and Error Messages

The following Microsoft Knowledge Base articles discuss error messages you may receive when working with FrontPage and databases:

• Q200973 - FP2000: FP98 Extended Server with Send to Database Form Handler Results in Error
• Q204152 - FP2000: Database Connection Undefined After Publishing Web
• Q205972 - FP2000: Too Few Parameters Error Previewing Page w/Database Region
• Q219079 - FP2000: Error Message: "The server encountered an error while processing the database request"
• Q219158 - FP2000: Save to Database Form Gives Confirmation but Does Not Add Data to Database
• Q219159 - FP2000: Database Pages Created Before Running Asp.exe on Personal Web Server 1.0a Return No Data
• Q219170 - FP2000: Error Browsing Database Results Pages After Publishing from Disk-Based Web
• Q219974 - FP2000: Error Message: "Cannot Update the Database" When You Submit Form Results to Excel Database
• Q225200 - FP2000: Custom Confirmation Component Displays Only Field Name If Called by Save to Database Form
• Q229295 - FP2000: HTTP Error 405 After Renaming Page with Database Search Form
• Q232532 - FP2000: Database Menu Item on Insert Menu Unavailable
• Q246570 - FP2000: Error Message: "Database Results Error Description ... Data Type Mismatch in Criteria Expression"
• Q256136 - FP2000: Database Results Error When Updating Record