hello,

I have a database question for you...I am having trouble with my page built in DW MX finding a database table as in error: "Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Departments'. Make sure it exists and that its name is spelled correctly."

page is www.focusdesign.com/york/employee_directory/directory_dept.asp

I'm a bit lost here as all is well and there are no errors when I check this locally using PSW and there are no changes whatsoever that I see between what I have on web and locally in terms of connections, etc. There is another table within the database that is being used by other pages with no problem. It seems as if this table is not being recognized. Table exists and spelling is correct.

Any ideas? I would assume this is something I'm missing but at this point I could use a hand.

thanks, Bob

code from page below:


<!--#include file="../../Connections/employees.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset"
Recordset1.ActiveConnection = MM_employees_STRING
Recordset1.Source = "SELECT * FROM Departments ORDER BY Department ASC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>

Try using the full path to the include file:

<!--#include file="../../Connections/employees.asp" -->

Regards

Owen.

-------------------------------------------------------------------------------------------
Used programming books and web development software for sale (UK only): www.tdsf.co.uk/tdsfdemo/Shop.htm

Developer services and tutorials: www.drdev.net

Multiple Parameter UD4 / Access 2000 Search Tutorial: www.tdsf.co.uk/tdsfdemo/

thanks for your help, Owen. I tried as you suggested and no luck. I have it back to what it is here. Any other thoughts?

Bob

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
thanks for your help, Owen. I tried as you suggested and no luck. I have it back to what it is here. Any other thoughts?

Bob
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>



It seems as though there was some issue with the table itself. I recreated it and all is well.
Bob