Author |
Topic  |
Roland
Advanced Member
    
Netherlands
9335 Posts |
Posted - 16 October 2004 : 15:21:57
|
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 |
|
Roland
Advanced Member
    
Netherlands
9335 Posts |
Posted - 16 October 2004 : 17:57:40
|
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. |
 |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 16 October 2004 : 20:42:22
|
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 |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 17 October 2004 : 05:24:26
|
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 |
 |
|
Roland
Advanced Member
    
Netherlands
9335 Posts |
Posted - 17 October 2004 : 13:00:01
|
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? |
 |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 17 October 2004 : 13:53:53
|
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 |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 17 October 2004 : 15:11:07
|
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 |
 |
|
Roland
Advanced Member
    
Netherlands
9335 Posts |
Posted - 17 October 2004 : 15:49:06
|
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. |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 17 October 2004 : 16:42:00
|
rurib if you could try and do that for me, I cant seem to fix it... |
-Stim |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
Doug G
Support Moderator
    
USA
6493 Posts |
Posted - 17 October 2004 : 18:12:38
|
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 |
 |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 17 October 2004 : 18:15:34
|
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 |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 18 October 2004 : 13:03:51
|
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 |
 |
|
Topic  |
|