FrontPage 2002 Database Connection Errors

Posted on 2004-11-07
Last Modified: 2013-12-24
I am trying to set up an MS Access database on a site to gather data generated by a form. Whether I go through the Database Interface Wizard or simply right click the form and select Form Properties, then select Send to Database/Options, I keep getting one or two error messages. The first one is when I click on Create Database. The error message says:
"Server error: Unable to retrieve the list of record sources from a database using the connection string:
DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/Contact_Us.mdb.
The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
Source: ADO
Number: -2146824584 (0x800a0e78)"

Yet, it does create a .mdb file with the proper headings. Then if I click Okay, the next error msg says:
"A valid database table is required."

If I select the drop down menu Table to Hold Form Results, there is no table on the list. How can this all to work? I have searched the Microsoft FrontPage help pages, talked to tech support of the ISP, etc. Nobody seems to have the answer. I have a feeling it's like a magic trick - once you know how it's done it seems easy, but until then it's mystifying.  It must not be very complicated, since FrontPage and Access are designed to work together seamlessly. And yes, I do have FP Server Extensions installed on the web site.

Question by:Blue_Jay
    LVL 14

    Accepted Solution


    Forget about your errors now.  I do not recommend creating a database using the form.

    01- Create a new database on your desktop
    02- Create a table in it,  put in the tables the fields that will be available in the form  (name the fields without spaces)
    03- Import the database to your web using Frontpage
    04- Save the database in the fpdb file when you are asked
    05- Go to Tools>Web Settings >Databases and verify the database
    06- Create the form.  The form should have the same fields that are in the table.  Give the form fields the exact names of the table.

    i.e:  If the table has EmployeeID,  EmployeeDept, Salary  the form field names should be exactly the same.

    07- Right Click the form and select properties
    08- Select the database that you imported and then the table
    09- Go to Saved fields and double click on each field to select it's match in the table
    10- Save everything.

    This is a healthier way in doing things.  

    LVL 14

    Expert Comment


    If you tried my steps and you still get the error then read this article:


    Author Comment

    Thank you, hhammash. I followed your steps, but got the same error. I think that the Microsoft KB article may be correct -- that there are missing components that the server administrator must install in order for this to work. We shall see.
    LVL 14

    Expert Comment

    Good luck

    Author Comment

    Hhammash -- Thank you for the link to the MS KB article. It did turn out to be a problem on the ISP's server. They couldn't find the problem, but when they moved the site to a new server the problem was gone!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Now that Expression Web 4.0 ( is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
    When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure ( It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
    The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and Log…
    The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now