Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Microsoft JET Database Engine error '80004005'
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Richard
Starting Member

5 Posts

Posted - 20 April 2001 :  09:56:03  Show Profile  Send Richard an ICQ Message
Microsoft JET Database Engine error '80004005'

'E:\virtwww\iska.group\prokick2\fpdb\snitz_forums_2000.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/forum/inc_top.asp, line 48


- From what I have read, everything is in the correct please, all uploaded, changed in the config files, and yet I am still getting this, any ideas?

Kat
Advanced Member

United Kingdom
3065 Posts

Posted - 20 April 2001 :  10:08:13  Show Profile  Visit Kat's Homepage
Have you run the setup.asp?

KatsKorner
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 20 April 2001 :  10:25:05  Show Profile
Load the Where Am I tool from http://forum.snitz.com/archive/default.asp?catid=11&cattitle=Forum+Setup+Tools

Then edit your config.asp conntection string with the correct location of your DB.


======
Doug G
======
Go to Top of Page

Richard
Starting Member

5 Posts

Posted - 20 April 2001 :  18:15:43  Show Profile  Send Richard an ICQ Message
The location is set, and its exactly the same, what I had was correct, and yet it can't find it. Setup.asp says:

The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.



Code : -2147467259


Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 20 April 2001 :  21:08:13  Show Profile
Can you post the section you edited in config.asp

just post everything between:

'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################

strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
Go to Top of Page

Richard
Starting Member

5 Posts

Posted - 20 April 2001 :  21:16:25  Show Profile  Send Richard an ICQ Message
After the day I got that bit to work, missing " at the end..

For nearly every page, including the default.asp there is this message:

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/scripts/inc_functions.asp, line 673


Any ideas about this one?
I'm new to ASP, so excuse me If these are easy, or stupid questions.


Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 20 April 2001 :  21:59:28  Show Profile
Basically it means that the database can't be written to.

The permissions on the directory where the database resides aren't setup correctly.
Go to Top of Page

Richard
Starting Member

5 Posts

Posted - 21 April 2001 :  12:00:12  Show Profile  Send Richard an ICQ Message
As in chmod? Its running on a win2k server, I thought chmod was for *nix systems only.. Or some sort of other permissions?

Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 21 April 2001 :  12:13:36  Show Profile
Do a search for "Operation must use an updateable query." here on the forums. The Search link is at the top right hand corner.

CHMOD is for Unix, that's not what he meant by it. He meant the NT permissions for the directory.

Go to Top of Page

TooOld
Starting Member

USA
3 Posts

Posted - 23 April 2001 :  17:28:08  Show Profile
quote:

Operation must use an updateable query.



Let me guess... you are using a win2000 server???

This [can] mean that the database is read only when it should be read/write but... you can also get this message on busy busy busy boards with lots of writes to the database.

I have an access website that ran perfect for years on nt4 and after changing to win2000, suddendly started giving intemitent "Operation must use an updateable query." errors - I say intermitent because 90% of the time it was fine, then all at once I'd get a rash of the errors from code that only minutes before was running clean.

Solution? I went back to NT4 and the errors went away - haven't had one in over 3 months.

As usual... YMMV

-pat-
Go to Top of Page

Adul
Starting Member

37 Posts

Posted - 23 April 2001 :  18:22:27  Show Profile  Visit Adul's Homepage  Send Adul an AOL message  Send Adul an ICQ Message
Edit the properties for the database. Go to the security tab and give write permission. That is why you get this error under win2k.



Edited by - adul on 23 April 2001 18:23:32
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.25 seconds. Powered By: Snitz Forums 2000 Version 3.4.07