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
%>

Have you made the ODBC Microsoft Access DSN name to your server?

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