DNS can't locate table

[phoenix1]

Hello,

I am new to Access and have built a database containing a single table for a demo. In addition, I have a single threaded form that spans across 9 web pages taking the user through the form step by step.

When the form goes to process, I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'tblMain'.

/Tufts/ISRC/Action_Items/New_Employee/Summary/SummaryMail.ASP, line 28

The page has no problem finding the database itself but for some reason cannot see the table inside the database.

Here is the connection string to the db:

strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("ISRC.mdb&quot

Here is the general script to the table:

strSQL = "INSERT INTO tblMain(name, address...

Can anyone give me some advise on what could be the problem? Please let me know if you need anything further in order to come to some conclusions.

Thank you for your comments.

Sincerely,

Tim

 

[DougP]

I suppose the is a table called tblmain in that database.
You may want to double check th espeling of it.

Also try putting a space after tblmain

strSQL = "INSERT INTO tblMain(name, address...
like this:
strSQL = "INSERT INTO tblMain (name, address...

also it looks like you need a "&" after this
strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath & ("ISRC.mdb&quot


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[phoenix1]

Doug,

Thank you for your thoughts. Here is what I did. I placed a space after the tblMain to no avail. I continue to get the same message. When I place the second & sign in the connection string I get an error:

Microsoft VBScript runtime error '800a01c2'

Wrong number of arguments or invalid property assignment: 'MapPath'

/Tufts/ISRC/Action_Items/New_Employee/Summary/SummaryMail.ASP, line 18

As I stated, it seems odd that the database is located but that the table inside the database is not visible to the application.

One thing that I noticed is that I have not found a specific method to save the database in access. I just created it in its current location and then close access. It seems to work fine, access has no problem finding it or allowing me to edit it, and neither does Interdev's dataview.

Let me know if you have any further thoughts.

Thank you.

 

[DougP]

I usually add on record to the table first from Access.
That way I can try to view that record too.

try prtinting the strSQL to the WEB page like so

<%response.write strSQL%><br> 'this is VBScript

then you can examine to see if it looks right
On rare occasion's the Error is NOT the what is it stating, but something else in the SQL string.
So make sure the entire string looks correct



DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.