Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Customer information forms not communicating with Access

Status
Not open for further replies.

Gmozeley

Technical User
Apr 23, 2001
6
US
I have created forms for people to input information into a request page using Frontpage 2000 and should send the data to Access 2000. My information is being displayed properly coming out of the database results but it doesnt seem to take incoming information. The error that I am recieving is "Cannot open record set Error Description: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Customer'. Make sure it exists and that its name is spelled correctly.
Error Number: -2147217865
Error Source: Microsoft OLE DB Provider for ODBC Drivers"

Please help me resolve this problem... I have had any experience with this type of asp.

Thank you in advance

GMozeley
 
The error you're getting has to do with your database. It's saying that the customer table in your database doesn't exist.

Check your database to make sure that it's there, and also check your SQL query to make sure that you are inserting correctly

hth
leo leo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top