Lately, I've been getting this error every so often on my forum:
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.
/forum/inc_header.asp, line 131
Line 131 is:
my_Conn.Open strConnString
I just end up refreshing the page and all is OK. What is causing it to do this at random times?<
I would suggest that you download your Database and run it through Access and with the following steps for Access 2003:
Tools > Database Utilities > Compact and Repair Database...
From what I have been reading, the error normally means that the Database is Corrupt as the error message also points out, so the earlier that you do a repair on it (do a backup of the Database first), the better off you are. <
With much nervousness I did a compact and repair. I backed up my database twice just to be safe.
I shut down the forum.
I then downloaded it to my computer, and opened it in Access 2007. I chose to Compact and Repair. It decreased the size of it from about 9MB to 6.7MB.
I then uploaded it back to my server.
Everything seems to be working fine.
However, I have a question. After I uploaded it I expected to have to go back in the admin options and open the forum back up. But it was already open. Is this normal? This is the first time I have ever done this to my database. I'm just curious.<
Knowing it was a few weeks ago Leatherlips, but prior to your download of the db, did you shut the forum down. If, after the upload of the repaired/compacted db, the forum ran straight away I would have thought it was not closed first.<
I have a small site using an Access db on a certain host. The same error you got, I have gotten for YEARS! I have reported it with no resolve. I've not had to do anything other than wait, and it clears up on its own. I am not an IIS man, but I gather it is something with the host's IIS not communicating with the db. The site is rather inactive because we don't promote it, so for that reason we haven't changed hosts. However, I will say that I am not currently buying more packages with that host.<
Topic Locked
Posted - 28 June 2008 : 17:28:01
