Microsoft ODBC Error - Can It Be Fixed?

I am using Dreamweaver 2004 and a Microsoft Access 2007 mdb file to access a table.
I am using a Windows 2008 Server set to use a 32-bit driver.

I set up a database connection on the server using ODBC

Inside Dreamweaver I create an ASP page.

Inside Dreamweaver I set up a Query that uses a select statement with a Datasource name of OpenOrdersCustomers. The Table name is BareDieDataSheets.

Inside Dreamweaver I am able to test the link to the table and actually view the table.

When I go to view the web page in an Internet Exlporer 8 browser I get the error message below.
On Line 8 that ithe error refers to it says
BareDieDataSheets.ActiveConnection = MM_OpenOrdersCustomer_STRING
How do I fix this error as I am not a programmer?
Thank you...

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine could not find the object '(unknown)'. Make sure the object exists and that you spell its name and the path name correctly.
/BareDieDataSheets.asp, line 8
Who is Participating?
Thanks, Rick. It looks like the definition for MM_OpenOrdersCustomer_STRING is set in the file:
Can you search that file for lines like:

MM_OpenOrdersCustomer_STRING = . . .

I'm guessing that there is a file path that
 can be resolved on your local machine (works in DreamWeaver) that cannot be resolved on the server (doesn't work in IE).

Can you post the rest of the ASP (or at least lines 1 - 8) ?

(just obscure the PWD=XXX part of your connection string).

ES-ComponentsAuthor Commented:
Here is the code you requested.
Thank you...

<!--#include file="Connections/OpenOrdersCustomer.asp" -->
Dim BareDieDataSheets
Dim BareDieDataSheets_numRows

Set BareDieDataSheets = Server.CreateObject("ADODB.Recordset")
BareDieDataSheets.ActiveConnection = MM_OpenOrdersCustomer_STRING
BareDieDataSheets.Source = "SELECT * FROM BareDieDataSheets"
BareDieDataSheets.CursorType = 0
BareDieDataSheets.CursorLocation = 2
BareDieDataSheets.LockType = 1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.