February 5, 2007 at 4:37 pm
I gues that .mdb file is corupted, but not sure.
When trying to access any page, I'm getting
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 'ProductClass'. Make sure it exists and that its name is spelled correctly.
Table does exist on the Server and is not misspelled...
Empty.mdb - 64kb file. Error message when trying to open the file.
Is there any way to rebuild the .mdb file, and how???
Thanks a lot
L.T.
February 6, 2007 at 3:29 am
Can you view the mdb file with Access to list its contents? I hope you have a backup.
February 6, 2007 at 5:46 am
Just so that I am clear. From all of your post, you have an Access database (mdb) that has a linked table that is a SQL server table. But you get the error you mention when trying to read that table.
What are you doing when you get the error? What application is running?
Russel Loski, MCSE Business Intelligence, Data Platform
February 6, 2007 at 8:14 am
no.
the backup is the same as original one.
February 6, 2007 at 8:17 am
not running any application.
just trying to open the web pages.
all pages are with the same error
http://www.amcan-impex.com/www/
this is the temp site i'm trying to change with the current one.
February 6, 2007 at 9:11 am
The web application (yes, there is an application there) that has a web page called index.asp is running a query on line 85. Somewhere before that is a connection string that is pointing to an Access database. That database should have a linked table called ProductClass that links to your SQL Server, if I understand you right.
I would need to see the relevant section of index.asp to suggest a solution.
Russel Loski, MCSE Business Intelligence, Data Platform
February 6, 2007 at 9:16 am
<%
SQLQuery2 = "SELECT * FROM ProductClass"
(HERE IS THE LINE 85)Set rsClassList = conn2.Execute(SQLQuery2)
Do While Not rsClassList.EOF
Response.Write (" " & rsClassList("Class") & "
")
rsClassList.MoveNext
Loop
rsClassList.Close
Set rsClassList = Nothing
SQLQuery2 = ""
%>
February 6, 2007 at 10:19 am
The database file is indeed completely empty.
Do you have a back up of the mdb? The access database should not have any data, just tables linked to the SQL Server, thus you won't be losing any data.
Someone may be able to very easily change your database access code (which is very nicely in a separate file) so that it directly connects to SQL Server rather than via Access.
Russel Loski, MCSE Business Intelligence, Data Platform
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply