The Microsoft Jet database engine cannot find the input table or query
'Table1'. Make sure it exists and that its name is spelled
correctly.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet
database engine cannot find the input table or query 'Table1'. Make
sure it exists and that its name is spelled correctly.

Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace
below.

Stack Trace:

[OleDbException (0x80040e37): The Microsoft Jet database engine cannot
find the input table or query 'Table1'. Make sure it exists and that
its name is spelled correctly.]

System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(OleDbHResult
hr) +1003520

System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS
dbParams, Object& executeResult) +255
System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object&
executeResult) +188
System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior
behavior, Object& executeResult) +58

System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method) +161
System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior
behavior) +116

System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandBehavior
behavior) +4
System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +130
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +287
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable) +92

System.Web.UI.WebControls.SqlDataSourceView.Execut eSelect(DataSourceSelectArguments
arguments) +1297

System.Web.UI.WebControls.AccessDataSourceView.Exe cuteSelect(DataSourceSelectArguments
arguments) +58
System.Web.UI.WebControls.ListControl.OnDataBindin g(EventArgs e)
+95
System.Web.UI.WebControls.ListControl.PerformSelec t() +34
System.Web.UI.WebControls.BaseDataBoundControl.Dat aBind() +73
System.Web.UI.WebControls.BaseDataBoundControl.Ens ureDataBound()
+82

System.Web.UI.WebControls.BaseDataBoundControl.OnP reRender(EventArgs
e) +22
System.Web.UI.WebControls.ListControl.OnPreRender( EventArgs e) +18
System.Web.UI.Control.PreRenderRecursiveInternal() +80
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+842

Are you executing code in a Microsoft Access Database? It does not appear
so. If not, then you would have a higher probabilty of finding an answer to
your question if you asked in a newsgroup devoted to the environment where
the error is occurring.

Here are a few comments that I can offer. My experience with that message
using Access with the Jet database engine is that it is entirely accurate.
Every time it has told me that Jet cannot find a table or query, there has
not been such a table or query. Your first avenue of debug might be to open
a copy of the Jet database you are trying to access with Microsoft Access
and determine if there is actually a "Table 1". Then you may need to open
the code you are actually executing (whatever it is) in debug or design view
to see just what/where/why it is requesting "Table1". "Table1" is likely a
default table name, but most developers of Jet databases (unless they are
totally immersed in some other language's code, e.g., C++, VB.NET, C# and
clueless about databases) rename their tables to some meaningful name.

If your followup questions are not directlly related to Microsoft Access,
Microsoft Access VBA, and Access' use of Jet, it is unlikely that I'll be
able to offer additional comments.

Larry Linson
Microsoft Office Access MVP

"saran" <srnskr708 (AT) gmail (DOT) com> wrote

I would suggest you should use Google to search Stackoverflow.com,
and if you don't find an answer to this question, post it on SO.
Your question is not really a Jet database engine question at all.
There's something else going on, as Larry has suggested -- you are
trying to operate on a table name that really does not exist, and
that's likely because of an error somewhere in your code (i.e., not
at all related to Jet itself).

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/