Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Help with DB error!!!
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Help with DB error!!!

 Post Reply Post Reply Page  12>
Author
rhearn View Drop Down
Newbie
Newbie


Joined: 16 October 2003
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote rhearn Quote  Post ReplyReply Direct Link To This Post Topic: Help with DB error!!!
    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>?????

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
rhearn View Drop Down
Newbie
Newbie


Joined: 16 October 2003
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote rhearn Quote  Post ReplyReply Direct Link To This Post 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.



Edited by rhearn
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 17 October 2003 at 8:04am
Have you checked on Microsofts web site?
Back to Top
rhearn View Drop Down
Newbie
Newbie


Joined: 16 October 2003
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote rhearn Quote  Post ReplyReply Direct Link To This Post Posted: 17 October 2003 at 8:14am

ummm. yeah. I've checked many many sites

Back to Top
huwnet View Drop Down
Senior Member
Senior Member


Joined: 30 May 2003
Location: England
Status: Offline
Points: 1375
Post Options Post Options   Thanks (0) Thanks(0)   Quote huwnet Quote  Post ReplyReply Direct Link To This Post Posted: 17 October 2003 at 10:23am
Maybe the patch needs the access drivers updated/reinstalled? Or maybe a virus?
Back to Top
rhearn View Drop Down
Newbie
Newbie


Joined: 16 October 2003
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote rhearn Quote  Post ReplyReply Direct Link To This Post 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.

Back to Top
Scorn View Drop Down
Newbie
Newbie
Avatar

Joined: 29 June 2003
Location: United States
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote Scorn Quote  Post ReplyReply Direct Link To This Post 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?



Edited by Scorn
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.