Help with DB error!!!
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=6490
Printed Date: 03 April 2026 at 5:57pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Help with DB error!!!
Posted By: rhearn
Subject: Help with DB error!!!
Date Posted: 16 October 2003 at 11:30pm
|
Last night at midnight, the 5 MS patches got automatically applied to my web server. Since then my Access DB has not worked. I have tried all sorts of things to get it to work, to no avail (including changing permissions, using DSNs, alternative connectors, copying different databases, changing directories, etc). The error displayed is:
Microsoft JET Database Engine error '80004005' Unspecified error /forum/common.asp, line 232 Line 232 is the command to open the DB. Everyone has Full Control to this file, the IIS admin shows write access to the file. Earlier today, if looked like this site was having the same issue with the DB being down, and now it's fixed. Can anyone help>????? |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 17 October 2003 at 2:32am
|
Make sure you are running the latest MDAC drivers from
www.microsoft.com/data also make sure that the database type is not
Access 97 which is no longer supported by the MDAC drivers.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: rhearn
Date Posted: 17 October 2003 at 7:38am
|
I re-installed the latest MDAC last night and I'm running Access 2000. I reconverted to Access 2000 format to check. Same error. Just for reference...I can run this database just fine on my test server, which happens to be unpatched. My production server, which is patched, will not run the DB. Just in case it was just Access, I was trying to convert to SQL. I can't even run the SQL setup script. Oh yeah, and I uninstalled all five patches and still not running. It's just very interesting that the patches were applied at 12:00 and all activity on my web site stopped then as well. |
Posted By: WebWiz-Bruce
Date Posted: 17 October 2003 at 8:04am
|
Have you checked on Microsofts web site?
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: rhearn
Date Posted: 17 October 2003 at 8:14am
|
ummm. yeah. I've checked many many sites |
Posted By: huwnet
Date Posted: 17 October 2003 at 10:23am
| Maybe the patch needs the access drivers updated/reinstalled? Or maybe a virus? |
Posted By: rhearn
Date Posted: 17 October 2003 at 4:26pm
|
I uninstalled / reinstalled Access and a bunch of other stuff. Finally, I gave up and upgraded the site to SQL. It works fine now. Arghhh. |
Posted By: Scorn
Date Posted: 23 October 2003 at 10:05am
|
I've had the EXACT same trouble. Following some patches, any ASP page I have that used an Access database has bombed. Sometimes, after only god knows what, ti will work, but if I dare reboot or patch, the forums or anything else access related goes down. The Microsoft site has been no help and no one knows anything about this. Has anyone else had this problem or even better, found a fix for it? |
Posted By: kmacy
Date Posted: 23 October 2003 at 10:23am
| try using the new access database that comes with 7.5. See if that works. |
Posted By: huwnet
Date Posted: 23 October 2003 at 10:50am
| I doubt that would work if it works on his production server! |
Posted By: Scorn
Date Posted: 23 October 2003 at 10:52am
|
It is on my production server, but I set up a new one just to see if it would work. It doesn't work. If I restart IIS or reboot, all pages will work for a few minutes but then it just stops. All other pages work and page using my Interbase Database for data contionue to work as well. This only applies to access. Sucks too, since these forums are sweet and Microsoft can't seem to get past tha fact that I get no error messages other than timeouts. |
Posted By: Scorn
Date Posted: 23 October 2003 at 1:02pm
So is there a cheap version of SQL Server anywhere? 
|
Posted By: WebWiz-Bruce
Date Posted: 23 October 2003 at 4:55pm
|
MS do a desktop version that can be downloaded free from their site.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |