Monday, December 17, 2007

What can I do if error Cannot-Find-Input-Table occurred?

What can I do if error Cannot-Find-Input-Table occurred?


Field name typo error happened in the ASP codes below:



<%

Set conn = Server.CreateObject("Adodb.Connection")

conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("db1.mdb")

Set rs = Server.CreateObject("Adodb.Recordset")

strSQL ="SELECT MemberName FROM Members;" ‘The Error is occur here.

rs.Open strSQL,conn,1,3

..

..

rs.Close

Set rs = Nothing

%>

When this error occured, which means you used an invalid table name, or the table name is not in the database, you will need to correct that specific ASP file to avoid the error message as shown at the diagram above.

No comments: