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