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:
What it suggested was:
delete and re-add the DSN (I tried that and it didn't work)
Use an OLEDB connection, and referred you to this URL:
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. :)
- Music Around The World
For collecting tips, trade and want lists, album reviews and more.