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

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 XP doesn't save my security settings :(
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

Roland
Advanced Member

Netherlands
9335 Posts

Posted - 16 October 2004 :  15:21:57  Show Profile
I've had this problem for some time now, but it's really getting on my nerves. When I want to connect to a test site on my computer that's connected to a database, I keep getting the 80004005 error. Each time I have to go to the right directory and set the permissions for the CREATOR OWNER user, the one for my XP account is fine.

How can I get XP to remember the security settings?

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 October 2004 :  17:18:24  Show Profile  Send ruirib a Yahoo! Message
The 80004005 error ocurring, is it the updateable query error, or a different one?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Roland
Advanced Member

Netherlands
9335 Posts

Posted - 16 October 2004 :  17:57:40  Show Profile
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'xxxxxxxxx'. It is already opened exclusively by another user, or you need permission to view its data.

It's not opened by anyone, it's the permissions not sticking.
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 16 October 2004 :  20:42:22  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
I'm having the same problem and its really starting to get on my nerves also...

how are you accessing your page? by http://localhost or by http://yourcomputername ? when i access through my computer name it works fine, but localhost is a *** to me

-Stim
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 October 2004 :  05:24:26  Show Profile  Send ruirib a Yahoo! Message
Have you set permissions for the Internet Guest account over that folder and files? That's the account that needs permissions set for the database to be accessed from IIS.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Roland
Advanced Member

Netherlands
9335 Posts

Posted - 17 October 2004 :  13:00:01  Show Profile
I have Administrators, CREATOR OWNER, my own account, SYSTEM, and Users.
Administrators, my account, and SYSTEM have all permissions set to allowed, except the "special permissions".
CREATOR OWNER has none of the permission set to allowed except the special permissions.
Users has all permissions set to allowed except "Full Control", "Modify" and "special permissions".

If I set the permissions for CREATOR OWNER, I can access the database.
I store the databases in the wwwroot with the site's files, not in a database directory outside the wwwroot. It's much easier to keep track of things this way. Maybe this has something to do with it too?
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 17 October 2004 :  13:53:53  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
The problem I'm having is, I can add records to the database, however I cannot modify (UPDATE) them or remove (DELETE) them... I have all permissions set for all users and it still wont work. I upload to a webserver and it works fine...

I dont get how I can add records just fine I just cant modify them.

-Stim
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 October 2004 :  15:11:07  Show Profile  Send ruirib a Yahoo! Message
I find it simpler to create a folder for the database files. AFAIK the important security permissions when accessing the database file are those of the Internet Guest Account (user name is IUSR_YourComputerName). If you don't have that user in the list, add it and grant it read and write access to the database folder. After doing that, click the Advanced button, check the option to replace permissions in child objects and click the OK button.
That's what I needed to do when I first setup IIS on my XP running computer.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Roland
Advanced Member

Netherlands
9335 Posts

Posted - 17 October 2004 :  15:49:06  Show Profile
The reason I store the databases with the site files is for FTP purposes... it's just easier to move up/down one directory than three :)

I'll give your suggestion a try and see if that fixes things.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 October 2004 :  16:34:46  Show Profile  Send ruirib a Yahoo! Message
Ok, let me know how it goes.

If anyone of you need, I can try and fix it with XP's remote assistance.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 17 October 2004 :  16:42:00  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
rurib if you could try and do that for me, I cant seem to fix it...

-Stim
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 October 2004 :  17:45:31  Show Profile  Send ruirib a Yahoo! Message
I'll email my MSN email address to you. Add me to your contact list.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 17 October 2004 :  18:12:38  Show Profile
Give the IUSR_computername full permissions. If your web server isn't exposed to the Internet, or if you're feeling frisky, add the IUSR_ user account to the local administrators group on you server and see if your problems vanish.

If your IIS server allows anonymous access (the default mode) then it uses the IUSR_computername user account for unauthenticated users.

======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 17 October 2004 :  18:15:34  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
quote:
Originally posted by ruirib

I'll email my MSN email address to you. Add me to your contact list.



You're on my contact list...

-Stim
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 18 October 2004 :  10:36:59  Show Profile  Send ruirib a Yahoo! Message
Ok. I'll be busy for the afternoon, but I can do it tonight (in about 7 hours).


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 18 October 2004 :  13:03:51  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
I'll be on and off all day, I share this computer with my sister so its hard to say when I'll be online or not, I'll try to catch you though.

-Stim
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 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.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07