In the last several days, my database has been down several times with the following error:

Microsoft JET Database Engine error '80004005'

Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.


In searching the archives for this forum, I found this thread:
http://p2p.wrox.com/archive/asp_data...2001-02/39.asp

What it suggested was:
delete and re-add the DSN (I tried that and it didn't work)

or

Use an OLEDB connection, and referred you to this URL:
http://www.adopenstatic.com/faq/OLEDBConnection.asp

I tried that, as follows:

strDBPath = Server.MapPath("/database/CDTrust.mdb")
CONN_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & "; "

Still got the same error. Now, after turning in a support ticket to my web host (again!) they tell me they converted my database to Access 2002 to solve the problem (it's presently Access 97 on my PC).

Here are my questions:

(1) Isn't there a better way to solve this problem?

(2) Does this mean that they'll have to convert it to 2002 every single time I upload a new version of the database? At least, that is, until I'm able to do the conversion myself (I don't have 2002).

Thanks in advance for any and all insight and help. :)

Pat Wong
http://www.napathon.net/ - Music Around The World
For collecting tips, trade and want lists, album reviews and more.

__________________
Pat Wong
http://www.napathon.net/ - Music Around The World
For collecting tips, trade and want lists, album reviews and more.

Hi vinyl-junkie

First Yourwant to Write this query to global.asa
'''''''''''''''''''''''''''''''''''''''''''''
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
        Application("Cnn_ConnectionString") = "DSN=CDTrust;DBQ=c:\database\CDTrust.mdb;DriverId= 281;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;"
        Application("Cnn_ConnectionTimeout") = 15
        Application("Cnn_CommandTimeout") = 30
        Application("Cnn_CursorLocation") = 3
        Application("Cnn_RuntimeUserName") = ""
        Application("Cnn_RuntimePassword") = ""
End Sub
</SCRIPT>
'''''''''''''''''''''''''''''''
and make a DSN (name:"CDTrust")

1.Open the ODBC icon in your Control Panel.
2.Choose the System DSN tab.
3.Click on Add in the System DSN tab.
4.Select the Microsoft Access Driver. Click Finish.
5.In the next screen, click Select to locate the database.
6.Give the database a Data Source Name (DSN).
7.Click OK.
'''''''''''''''''''''''''''''
then u can write a asp page
<%
set cnn=Server.CreateObject("ADODB.connection")
cnn.Open Application("Cnn_connectionstring")
set rs=Server.CreateObject("ADODB.recordset")
sql= "select * FROM tablename "
rs.Open sql,cnn,1,3
%>

surendran

Maybe you need some professional services. I think you can try a utility called Advanced Access Repair to repair your Access MDB file. It works rather well for my corrupt Access MDB files. Its web address is http://www.datanumen.com/aar/

Just post to hope this still can help.

fyz