Error with "undefined"

The search page throws an error
Microsoft JET Database Engine error '80040e37'

The Microsoft Jet database engine cannot find the input table or query 'undefined'. Make sure it exists and that its name is spelled correctly.

/delta/DeltaAlloys_search.asp, line 13

In the recordset everywhere there should be a table or field and the query name is undefined instead. I reworked the wizard and got the same results. I can manually change everything on the page, but that is why I have DataAssist - so I don't have to write the code for this.
And while I am in a bummed mood I think it rotten that a forum is the best I can do when their product isn't working.

please send a copy of your page so I can examine the code.


also, what version of data Assist?

What is your Operating System?

and What version Of Dreamweaver are you using?

My Computer windows 7 - server Windows ? (iPower)
DataAssist 2
Can be seen at DeltaAlloys_search.asp

Forgot to put the DW version: CS5

please send a copy of the delta/DeltaAlloys_search.asp page in a zip archive so I can see the code.

I attached the file before, but didn't realized it needed to be zipped. While I am at it I have put the results page and details in also.

So it looks like the issue is the recordset being used to populate the Alloy Group select list.

How is that table defined? can you send a screen shoot showing how the Allow group table is created.

I am not sure what you are requesting? Do you mean a screenshot of the table or a screenshot of the design view of the table or ? ? ? At any rate for me this is a moot issue now. While waiting I created my own code using dreamweaver.

I meant a screen shoot of MS Access showing the how the table is defined, column names and data types.

The design view of the table is attached.