FrontPage 2002 Database Connection Errors

Posted on 2004-11-07
Medium Priority
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
  • 3
  • 2
LVL 14

Accepted Solution

hhammash earned 1500 total points
ID: 12519608

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

ID: 12519624

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



Author Comment

ID: 12520571
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

ID: 12522228
Good luck

Author Comment

ID: 12574770
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!

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
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…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…
Suggested Courses
Course of the Month13 days, 16 hours left to enroll

807 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